Functions

NULLIF(Quantity,0) 

NULLIF() is a nifty little SQL function that helps you compare two expressions—and if they're equal, it returns NULL. If they're not equal, it returns the first expression.

--==========

ISNULL()

SELECT [FirstName], ISNULL(MiddleName,'--'), [Lastname]  //  return '--' if middlename is null

--==========

COALESCE()

SELECT  COALESCE(MiddleName,Title, 'No Middlename or Title')

-===========