ISNULL,NULLIF Functions

DECLARE @Char char(10)

SELECT @Char = NULL
SELECT ISNULL(@Char,'ABC' )

Result: ABC
SELECT @Char ='ABC'
SELECT NULLIF(@Char,'ABC')
Result: NULL