#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Location
    malaysia
    Posts
    13
    Rep Power
    0

    Sql statement to select a null field


    Hi Group

    Here is the sql statement :

    select DocNo,DocDate,BillNo from table where billno.isnull

    I know the billno.isnull is not allowed in the statement , but I how do I overcome this?

    Thx
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Location
    malaysia
    Posts
    13
    Rep Power
    0
    I finally found the answer ,just to share :

    select DocNo,DocDate,BillNo from table where billno Is Null
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2004
    Posts
    1
    Rep Power
    0
    to select not null rows fronm the table

IMN logo majestic logo threadwatch logo seochat tools logo