Checking null values in Query(SQL Server) Prob
my query in SQL Server is
Select * from userphotos where (name<>Null and photo<>Null)
There are 3 records that have values in both the fields mentioned but still it shows no records.
What is the proper method of checking null values?