IS NULL vs = NULL in where clause + SQL Server
- by Nev_Rahd
Hello
How to check a value IS NULL [or] = @param (where @param is null)
Ex:
Select column1 from Table1
where column2 IS NULL => works fine
If I want to replace comparing value (IS NULL) with @param. How can this be done
Select column1 from Table1
where column2 = @param => this works fine until @param got some value in it and if is null never finds a record.
How can this achieve?
