not null

[Guest]

Hi i have this query

<cfquery name="Sho" datasource="test
SELECT Email, ID
FROM Main_Clubs_Data
WHERE Email IS NOT NULL
</cfquery>

i want my output to show all records where email does not = Null

i thought my code was right but my output still shows the records with null in

any ideas

[Guest]

Tey Email <> NULL or NOT Email IS NULL. Also, if you copied and pasted your CFQUERY, you are missing a closing double quote after your datasource name.

[Dan_Bracuk]

change is not null to > ''