Can I not have multiple condition in a case like..
SET myVar = CASE UPPER(var)
WHEN 'AB' THEN '12'
WHEN 'CD' OR 'EF' OR 'GH' THEN '00'
END;
I tried
SET myVar = CASE UPPER(var)
WHEN 'AB' THEN '12'
WHEN IN ('CD' , 'EF' , 'GH') THEN '00'
END;
Gives me an error !!
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com