Do you mean:

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

If so then:

case "V_EMP_ALL"."HOMEDEPARTMENT"
when null then '*'
else "T_CO_DEPT"."DEPT_C"
end

-----Original Message-----
From: John Guderian
[mailto:oracledba-ezmlmshield-x91502654.[Email address protected]
Sent: Thursday, August 31, 2006 1:41 PM
To: LazyDBA Discussion
Subject: Convert Oracle SQL statement to MS SQL


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
===================================================================================




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




--
This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

Douglas County, Oregon
www.co.douglas.or.us


Oracle LazyDBA home page