Tag: NULLIF

NULLIF function in SQL Server

AbundantCode 1 month ago in SQL Server 0

The NULLIF function in SQL Server returns a NULL value if the two input expressions return the same value else the first value (expression) is returned. For example , assume that you want to compare two columns (Address1 and Address2) in the Address table and want to return NULL if both are same to indicate there is NO change and if the addresses are different…