Yes/No True/False in SQl

Results 1 to 2 of 2

Thread: Yes/No True/False in SQl

  1. #1
    Join Date
    Dec 1969

    Default Yes/No True/False in SQl

    I converted a Access DB to a sql server db via the tools in Sql manager. I used some Yes/no fields in access, which where converted to bit. I looked for a data type in SQL server called y/n or something close, does one exist or is bit it?<BR>Is there even away to do this or should I convert all my Yes/no fields to integers and use 1 and 0 instead?<BR><BR>Any help greatly appreciated<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Yes/No True/False in SQl

    Yes, bit&#039;s it. It can take values of 0 and 1.

Posting Permissions

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