CREATE TABLE table_24231638_3 (replaced_by VARCHAR, date_of_appointment VARCHAR)

Who replaced on the date of appointment 2 november 2010?
SELECT replaced_by FROM table_24231638_3 WHERE date_of_appointment = "2 November 2010"
SELECT "replaced_by" FROM "table_24231638_3" WHERE "2 November 2010" = "date_of_appointment"