use single quote ` for the literal expressions The column Test-W needs to be enclosed in dobule quote Select FLAGS, CASE FLAGS WHEN 0 THEN '10000000' WHEN 1 THEN '01000000' WHEN 2 THEN '00100000' WHEN 3 THEN '00010000' WHEN 4 THEN '00001000' WHEN 5 THEN '00000100' WHEN 6 THEN '00000010'...