CASE
 WHEN a=1 THEN 'HELLO'
 WHEN a=2 THEN ’TELL‘
 ELSE 'ELLE'
END 'Col_name'