sql server - SQL Query - how do filter by null or not null -


I want to filter a record ....

If the situation is unread, then record Filter (where position id is not empty)

If the status-status is not empty, then filter the record where the conditionalized state is equal to.

How can I do this?

as you said 

  select * tbl from where in Select Null   
 or  
  to select tbl * where the static is not empty   
 If your statacet is not empty , Then it will actually be okay for you when you have a real value, there is no need for any "if" argument, if you are thinking like this, then  
  to select * tbl Where position = 123 -   
 if the blank space is empty, then it Trying to appropriate no place or value,  
  select * tbl where Stetsat = 123 or Stetsat blank

Comments

Post a Comment