> I didn't have your table so I tried to write the same command by one of my > tables. my query which worked, is: > SELECT CASE WHEN left( workorder, 1 ) > IN ( 'C', 'T' ) > THEN 'group1' > WHEN left( workorder, 1 ) > IN ( '3', 'R' ) > THEN 'gorup2' > ELSE > 'group3' > END FROM workfile;
which is different from what you wrote in your previous email: > SELECT > CASE WHEN status IN('BR', 'VQ', 'RQ', 'NG' ) > THEN > 'binding' > CASE WHEN status IN('NA', 'NG', 'RA') > END as action > FROM master_info WHERE > (( status IN ( 'BR', 'VQ', 'RQ', 'NG' )) OR > ( status IN ( 'NA', 'NG', 'RA' ))); The difference being the CASE preceding the second WHEN in your first suggestion. The query that I got to work is as follows: SELECT CASE WHEN status IN( 'BR', 'VQ', 'RQ', 'NG' ) THEN 'binding' WHEN status IN( 'NA', 'NG', 'RA' ) THEN 'approving' END as action, status FROM master_info WHERE (( status IN ( 'BR', 'VQ', 'RQ', 'NG' )) OR ( status IN ( 'NA', 'NG', 'RA' ))); Thank you very much for your help, Mojtaba! Chris -mysql,query,blah -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]