Andrew Channels Dexter Pinion

Wherein I write some stuff that you may like to read. Or not, its up to you really.

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



SELECT InternalExternalIndicator,
CASE InternalExternalIndicator
WHEN 0 THEN 'Department'
WHEN 1 THEN 'Businesss Associate'
END AS 'Type'
FROM Department

Posted by: King on April 4, 2003 03:14 PM