2 Replies Latest reply on Aug 23, 2006 5:39 AM by Dan Bracuk

    not null

    richy2424 Level 1
      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