Hi ALL
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.
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.