Hi,

Does anyone know if the SQL version used in access supports IF or CASE statements? I have seen these in T-SQL.

Examples in T-SQL:

SELECT Category = CASE type
WHEN 'popular_comp' THEN 'Popular Computing'
WHEN 'mod_cook' THEN 'Modern Cooking'
WHEN 'business' THEN 'Business'
WHEN 'psychology' THEN 'Psychology'
WHEN 'trad_cook' THEN 'Traditional Cooking'
ELSE 'Not yet categorized'
END
FROM titles


I have tried CASE and IF in ACCESS 97 but it can't figure out the right syntax or any info on the HELP pages.

Many thanks,

RF

p.s. I know is not a VB question, but since VB is used in Access and many use Access... maybe one of you knows