Hi all,

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?
Pls guide.

regards

Vinay

Select * from userphotos where (name is not Null and photo is not Null)


Om Prakash

Omprakash Thanks for that... it worked.

regards,

Vinay