I'm trying to design a query/CASE statement that will ignore the case of a field. Example: 'APPLE' and "Apple'.
I would like to combine the following two separate statements into one statement.
WHEN FOOD = 'APPLE' THEN ' Fruit'
WHEN FOOD = 'Apple' THEN ' Fruit'
Thanks in advance!