SQL Query - how do filter by null or not null

Question

I want to filter a record      If statusid is null  filter the record  where statusId is not null   If statusid is not null  filter the record where statusid is equal to the specified statusid   How do I do this

User · Answer

set ansi nulls off go select   from table t inner join otherTable o on t statusid   o statusid go set ansi nulls on go

User · Answer

Just like you said  select   from tbl where statusid is null   or  select   from tbl where statusid is not null   If your statusid is not null  then it will be selected just fine when you have an actual value  no need for any  if  logic if that is what you were thinking  select   from tbl where statusid   123 -- the record s  returned will not have null statusid   if you want to select where it is null or a value  try  select   from tbl where statusid   123 or statusid is null

User · Answer

I think this could work   select   from tbl where statusid   isnull  statusid statusid

User · Answer

How about statusid   statusid   Null is never equal to null

User · Answer

Wherever you are trying to check NULL value of a column  you should use IS NULL and IS NOT NULLYou should not use  NULL or   NULL  Example NULL   select   from user registration where registered time IS NULL    will return the rows with  registered time value is NULL  Example NOT NULL   select   from user registration where registered time IS NOT NULL    will return the rows with  registered time value is NOT NULL  Note  The keyword null  not null and is are not case sensitive

User · Answer

WHERE something IS NULL   and   WHERE something IS NOT NULL

[sql] SQL Query - how do filter by null or not null

Examples related to sql

Examples related to sql-server

Examples related to database

Examples related to sql-server-2008