Post reply

Help with query ???

  • October 5, 2004 at 12:46 pm

    #161640

    i was wondering if anyone can help me with some code..

    I need to grab some data from a table in in my 7.0 database - I need to export or copy every row where the value is NOT null in a particular column.? In other words, there are 4820 rows in the table. I need to extract the 59 rows which have a value other than null in a particular column.

  • October 5, 2004 at 12:53 pm

    #525480

    SELECT * FROM tblTest WHERE ColC IS NOT NULL



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • October 5, 2004 at 12:56 pm

    #525481

    awesome. thank you very much!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply