What is the use of the NULLIF function?

Started by Jonathon, October 24, 2014, 11:37:55 AM

Previous topic - Next topic

Antony

Hello, I would like to ask you a very urgent question to ask you, what is the use of the nullif function? Thank you, please, for your assistance in this matter.

Jonathan

Description

In SQL Server (Transact-SQL), the NULLIF function compares expression1 and expression2. If expression1 and expression2 are equal, the NULLIF function returns NULL. Otherwise, it returns the first expression which is expression1.

Syntax

The syntax for the NULLIF function in SQL Server (Transact-SQL) is:

NULLIF( expression1, expression2 )