Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    3

    Unanswered: Select records having null values

    Hey,

    How do I select records from SQL DB where field value is null?

    Thanx,
    Twinkle

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189
    Hello,

    can you use

    where field IS NULL ????

    Hope that helps ?

    Regards
    Manfred Peter
    (Alligator Company)
    http://www.alligatorsql.com

  3. #3
    Join Date
    Aug 2002
    Location
    Kampala, Uganda - East Africa
    Posts
    13
    Hy,
    I think there is nothing like "null values". Something that has a value is not NULL!


    Otherwise, u can Select null records using

    SELECT field1,
    field2,
    field3
    FROM tabname
    WHERE fieldx IS NULL

    Note:
    I am assuming that fieldx is the null field to be checked.


    Nice time

    Sef

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •