varchar not null - zz12

Hello, just a quick novice question...how would the WHERE clause be written
to return rows that contain a value in leaving out the null rows?  Would it
be something like?:

SELECT varcharColumn1 WHERE varcharColumn1 <> NULL

Thanks in advance.

varchar not null - Stuart Ainsworth

You're looking for "IS NOT NULL"

Stu

varchar not null - Madhivanan

You cant compare NULL with arithmetic operators
As said use WHERE col IS NOT NULL
To find null values use WHERE col IS NULL