>My understanding that SQL Server BIT servers pretty much the same purpose as VFP Logical type column. If I have a table in SQL Server with a column type BIT and a table in VFP with the column type LOGICAL (basically the same-purpose table) can I use the same SQL Select or SQL UPDATE this column?
>
>For example, for SQL Server I would have:
>
>

>update MyTable Set MyField = '122'  where NewCol = 0
>select * from MyTable where NewCol = 1
>

>
>And for VFP the SQL commands would be:
>

>update MyTable Set MyField = '122'  where !NewCol
>select * from MyTable where NewCol
>

>
>Is there a way to make both cases work with the same syntax?

No. You need to be explicit in your syntax if you're using SPT.