This example shows the use of CASE in SQL.

select case gender when ‘M’ then ‘Male’
when ‘F’ then ‘Female’
else ‘Other’ end
from users

Works in Sql Server and Sybase.

😀