I want to convert my existing access database to sqlserver.
The Boolean Datatype in Sqlserver is converted to bit but my queries in VB stop working

if in VB I Say

Select * From Table WHERE BoolField=true

It Doesn't work???

what is the easy way to convery it to make it sql compatible