To get the equivalent of :

CASE
WHEN 'a' THEN 'Alabama'
WHEN 'A' THEN 'Arizona'
END

in a case insensitive database do the following:

CASE
WHEN char(97) THEN 'Alabama'
WHEN char(65) THEN 'Arizona'
END