I'm Using Sql Server 7.0
My Existing Project is VB6.0+MsAccess
I want To switch Over To SQL SERVER

Boolean Data Type in Ms Access is Converted to bit datatype in SQL SERVER

My Code in VB EveryWhere Has SqlStatements like

SELECT * FROM TABLE WHERE BOOLFielD=True

If I Run the Same in Query Analyzer It Gives the following Error

[Invalid column name 'true'.]

The Bit DataType Accepts 0 and 1
i need an easy way to convert my existing project so that i don't have to make a lot of changes