symbol for searching for null

Discussion in 'Optigold ISP' started by spacelink, Nov 3, 2005.

0
  1. #1
    Shawn,

    How do search for null?

    I want to find all payments that don't have anything in the notes field.

    Any ideas?

    Regards,

    Your loyal fan
    Stuart Clark
     
    spacelink, Nov 3, 2005 IP
  2. davediab

    davediab Peon

    Messages:
    31
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    where payments=""
     
    davediab, Nov 3, 2005 IP
  3. daboss

    daboss Guest

    Messages:
    2,249
    Likes Received:
    151
    Best Answers:
    0
    Trophy Points:
    0
    #3
    that is not correct... this is an empty string... not a null...

    try this:
    in SQL, use the words "NULL"
    in visual basic, use the "isNull" function
    in C, check for "\0"
     
    daboss, Nov 3, 2005 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    The equal sign (by itself) is what you are looking for.
     
    digitalpoint, Nov 4, 2005 IP