469,643 Members | 1,868 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

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 1142

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
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.