January 22, 2003
Oracle v SQL Server, Part 6
Not easy to find, but the equivalent of NVL in T-SQL is the function ISNULL. [Courtesy of SharePoint Portal Server]
I still can't find a direct equivalent for DECODE, but I shall continue to look.
Posted by Andy Todd at January 22, 2003 11:49 AM
Comments
http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm
e.g.
SELECT InternalExternalIndicator,
CASE InternalExternalIndicator
WHEN 0 THEN 'Department'
WHEN 1 THEN 'Businesss Associate'
ELSE NULL
END AS 'Type'
FROM Department