Select CASE WHEN Fieldname = 'A' THEN 1; WHEN Fieldname = 'B' THEN 2; WHEN fieldname = 'C' THEN 3; End case;as Fieldname