>>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?
>
>Yes you can use SQL that is common to both VFP and SQL server like this:
>
>

>update MyTable Set MyField = '122'  where cast(NewCol as int) = 0
>select * from MyTable where cast(NewCol as int) = 1
>

>
>PS: Actually you don't even need to do that and would use vanilla ice plain SQL using parameters:
>
>

>MyField = '122'
>newCol = .F.
>
>SQLExec(m.lnHandle, 'update MyTable Set MyField = ?m.MyField  where NewCol = ?m.newCol')
>
>newCol = .T.
>SQLExec(m.lnHande, 'select * from MyTable where NewCol  = ?m.newCol', 'myCursor')
>

>
>Or use simply use cursorschema with CA.
>
>Cetin

Thank you, Cetin.