CASE Expressions in Sql server
Posted on 2009-05-20
Hi i need to select a column and check if that column has value 'PS', if it has then i need to change the other column value to 'VNE' else WTE'. Here's my code , but iam getting the error message as invalid syntax near '=' . Please help me on this.
Eml.Fileno, eml.loc, eml.cmp=
THEN 'VNE' ELSE 'WTE' end
LEFT JOIN Eml ON Eml.Emp = Emp.Emp
LEFT JOIN Audtrl ON Audtrl.srcid = emp.empid
Audtrl.AudtrlDt <= '20090515' and eml.fileno is not null)
also i want to do another query where eml.loc should not be selected, but still need a CASE statement for the column eml.cmp for the above mentioned functionality. Hope you understood my question.