Hi, I'm have a question on syntax here. I want to classify each of seven variable values into one of two values and place the new values in a new column. I have success with the following syntax: CASE WHEN t1.'MEMBER CATEGORY DESC'n = 'Miscellaneous' then 'Non-Safety' WHEN t1.'MEMBER CATEGORY DESC'n = 'State Miscellaneous' then 'Non-Safety' WHEN t1.'MEMBER CATEGORY DESC'n = 'State Industrial' then 'Non-Safety' ELSE 'Safety' END Can I roll the conditions into one WHEN statement and one THEN statement, for example: CASE WHEN t1.'MEMBER CATEGORY DESC'n = ('Miscellaneous' or 'State Miscellaneous' or 'State Industrial') then 'Non-Safety' ELSE 'Safety' END It doesn't work, but could it work with different syntax? Thanks for your help. Dru
... View more