>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.
If it's not broken, fix it until it is.
My Blog