472,127 Members | 1,895 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.

SQL Server equavelent Boolean values


I currently have a project where i have to redefine certain table fields and their data types.

The problem is i have fields to mimic or duplicate an access table, but the problem is that certain fields are boolean values with yes/no attributes. Sql server does not support boolean values to my understanding. The sql server corresponding fields are of type char which is updated in a webpage by entering y or n values. Is their a way i can manipulate the the database fields in my sql server database to make it boolean values and receive 1 and 0's? Would using a bit data type for the char fields be a good idea?

The two databased must match, because it is part of an automated process.
Im using SQL Server 2000. version 8

Please any advice.
Jul 31 '07 #1
0 1196

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Harris Boyce | last post: by
8 posts views Thread by Metro Sauper | last post: by
6 posts views Thread by Daniel Walzenbach | last post: by
5 posts views Thread by Alan T | last post: by
reply views Thread by Nico Ploner | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.