ms sql server equivalent of oracle’s NVL function

Dec 16

oracle’s NVL function:

NVL( a1, a2 )

a1 and a2 are expressions
return a2 if a1 is NULL
return a1 if a1 is not NULL

ms sql server equivlent is the ISNULL function:

ISNULL ( a1, a2 )

a1 is checked for NULL
a2 is returned if a1 is NULL
return a1 if a1 is not null

ms sql server equivalent of oracle’s decode