Empty Integer field

From a BDE Table, with FIELDA (Integer), which sometimes is EMPTY, with
Query1 I want to retrieve all the records where FieldA is EMPTY.

In Query1 I have tried FieldA = '', FieldA =Ascii32, Field A = Blanks
without any success.

Could anyone show the correct coding to retrieve records based on
EMPTY integer fields?.

Thanks a lot in advance

Comments

  • : From a BDE Table, with FIELDA (Integer), which sometimes is EMPTY, with
    : Query1 I want to retrieve all the records where FieldA is EMPTY.
    :
    : In Query1 I have tried FieldA = '', FieldA =Ascii32, Field A = Blanks
    : without any success.
    :
    : Could anyone show the correct coding to retrieve records based on
    : EMPTY integer fields?.
    :
    : Thanks a lot in advance
    :
    :

    I would try: FieldA is null

    Seems to work on MsSQL Server 2000 anyway

    //Ulvert

  • : From a BDE Table, with FIELDA (Integer), which sometimes is EMPTY, with
    : Query1 I want to retrieve all the records where FieldA is EMPTY.
    :
    : In Query1 I have tried FieldA = '', FieldA =Ascii32, Field A = Blanks
    : without any success.
    :
    : Could anyone show the correct coding to retrieve records based on
    : EMPTY integer fields?.
    :
    : Thanks a lot in advance
    :
    :
    Dear Ulvert
    Thanks for youf suggestion.
    I've tried it but I regret to say it did not work.

    I'll appreciate another suggestion.

    Thanks again in advance.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories