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