Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Jun 2002
    Posts
    406
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to write where clause for a Bit column?

    I have a table which has the following columns with data types:

    tblProducts:

    ProductID int
    ProductName nvarchar
    IsValue bit (its either 0 or 1)
    Rank nvarchar

    So when I write a select statement how should I set the value for IsValue - meaning with single quotes or without any quotes as follows:

    SELECT ProductID, ProductName, IsValue
    FROM tblProducts
    WHERE IsValue = 0 ORDER BY Rank

    Is the above one correct or I should put the 0 within quotes or any other way?

  • #2
    Senior Coder nikkiH's Avatar
    Join Date
    Jun 2005
    Location
    Near Chicago, IL, USA
    Posts
    1,973
    Thanks
    1
    Thanked 32 Times in 31 Posts
    SQL Server needs no quotes for bit fields; so if that's your DBMS, there you are.

    If this post contains any code, I may or may not have tested it. It's probably just example code, so no getting knickers in a bunch over a typo, OK? If it doesn't have basic error checking in it, such as object detection or checking if objects are null before using them, put that in there. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
    Bored? Visit
    http://www.kaelisspace.com/

  • #3
    Regular Coder
    Join Date
    Jun 2002
    Posts
    406
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks nikkiH


  •  

    Posting Permissions

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