Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    54

    Unanswered: Bin and Boolean field in SQL

    Certainly an easy question,
    but I can't find the information.

    In Access db, in my SQL statement I used this syntax for boolean field :

    ... where myfield=no
    ... where myfield=yes

    After an SQL Server migration (upsize)

    This is not accepted.
    So I am looking for the SQL equivalence
    (The field has become a "bin" field)

    Thanks for this info,

    Is there a good documentation on SQL statement on the Net ?

    Pierre.
    Pierre (Pl-Arts)

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

    Post Moved to the access forum

    Hello,

    I have moved your post to the access forum.

    Best regards

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

Posting Permissions

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