Why Blank space is accepted and null keyword is not accepted

Asked Feb 05 '16 at 07:13

Active Feb 05 '16 at 07:13

Viewed 42 times

This is the Query

Select * from tblNewsLetterPetLookup where Category != ''

which is running ok, but whenever i am using

Select * from tblNewsLetterPetLookup where Category != null

It neither shows error nor the anticipated data,

The Column Category is declared as varchar(50)

I just want to know the reason why it is behaving such!!!!!!!!!!!

asked Feb 05 '16 at 07:13

because NULL is different from string you have to specify another condition for NULL https://technet.microsoft.com/en-us/library/ms191504%28v=sql.105%29.aspx – wiretext Feb 05 '16 at 07:17
Related: http://stackoverflow.com/questions/9581745/sql-is-null-and-null – Felix Pamittan Feb 05 '16 at 07:17
1

Use "Select * from tblNewsLetterPetLookup where Category IS NOT null" – D Mayuri Feb 05 '16 at 07:31

0 Answers0