Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Location
    Dallas, TX
    Posts
    77

    Unanswered: how to select record according one null column

    if i have table A, and column B, some records of B is null,
    i want to select all records when B is null? how do i do it. thanks a lot

    select * from A where B = null

    this doesn't work. any one know how to do it?
    thanks a lot

  2. #2
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    it should be;
    select * from A where B is null;
    ghozy.

  3. #3
    Join Date
    Sep 2004
    Location
    Dallas, TX
    Posts
    77
    thanks a lot, but......
    i got run time erro 94:
    invalid use of null


  4. #4
    Join Date
    Jun 2004
    Posts
    16
    You cant put criteria in the same column where you have an asterisk.

    Try:

    SELECT TableA.*
    FROM TableA
    WHERE (((TableA.B) Is Null));

Posting Permissions

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