Monthly Archives: May 2008

Comparing NULL values in SQL Server

Sometime we want to check for the values by comparing them with the NULL identifier. Like: DECLARE @str1 CHAR, @str2 CHAR  SET @str1 = NULL  SET @str2 = NULL  IF @str1 = @str2  SELECT ‘NULL Values Are Equal.’  ELSE   SELECT ‘NULL Values Are … Continue reading

Posted in SQL Server | 2 Comments