• Paul White NZ (9/12/2010)


    3. You can assign the string values 'true' and 'false' to a bit data type. 'True' will be stored as 1, and 'False' will be stored as 0.

    I believe this feature was introduced in SQL Server 2005.

    Nicely explained Paul and Gail:-)