I'm trying to do something like the following: SELECT CASE status WHEN IN ( 'BR', 'VQ', 'RQ', 'NG' ) THEN 'binding' WHEN IN ( 'NA', 'NG', 'RA' ) THEN 'approving' END as action FROM master_info WHERE (( status IN ( 'BR', 'VQ', 'RQ', 'NG' )) OR ( status IN ( 'NA', 'NG', 'RA' )));
But this query is obviously going to fail. But there _has_ to be a more elegant way than doing: WHEN 'BR' THEN 'binding' WHEN 'VQ' THEN 'binding' ... Is there? If so, I can't figure out what it would be. Any suggestions? thnx, Chris -mysql,query,blah -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]