Friday, April 5, 2013

Compare IS Null and any value in sql where Clause

select * from tablename
WHERE ((COLUMN1 = @PARAM) OR (COLUMN1 IS NULL AND @PARAM IS NULL))

No comments:

Post a Comment