Post reply

how to check bit field value?

  • December 24, 2008 at 2:45 am

    #94621

    Hello,

    I have a table which contains a bit datatype field called CancelFlag.

    How can I check whether CancelFlag value is not true?

    Thanks & Regards.

  • December 24, 2008 at 3:04 am

    #917284

    Where CancelFlag = 0

    A bit holds values of 1 or 0. By convention, 0 is false and 1 is true, though there's nothing in SQL that enforces that.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 24, 2008 at 3:13 am

    #917286

    thanks .

    but the column contains True,False & NULL value and i want all rows which doesn't contain True value.

  • December 24, 2008 at 3:24 am

    #917288

    ankur (12/24/2008)

    but the column contains True,False & NULL value and i want all rows which doesn't contain True value.

    Where Coalesce(CancelFlag, 0) = 0

  • December 24, 2008 at 3:31 am

    #917290

    It works.

    Thank you very much.

  • December 24, 2008 at 4:41 am

    #917308

    The Stright forward statement is

    WHERE CancelFlag = 'False' or CancelFlag IS NULL

    The bit datatype allows you to compare the column with value 'True' or 'False'

    Venkat

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy