Below is an oracle statement that I need to have converted into MS SQL.
I understand that Decode is similar to CASE, but Im not that versed in
SQL to figure this out.



(Decode("V_EMP_ALL"."HOMEDEPARTMENT",NULL,'*',"V_EMP_ALL"."HOMEDEPARTMEN
T") = "T_CO_DEPT"."DEPT_C")



Any help would be appreciated.



Thanks,



JG




===================================================================================
CONFIDENTIALITY NOTE:
This e-mail and any attachments are confidential and may be protected by legal privilege. If you are not the intended recipient, be aware that any disclosure, copying, distribution, or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please notify us immediately by returning it to the sender and delete this copy from your system

Thank you for your cooperation.

P.F. Chang's China Bistro and Pei Wei Asian Diner
===================================================================================



Oracle LazyDBA home page