>>Hi,
>>
>>I have a column/field which is Logical in VFP and BIT (not NULL) in SQL Server. The segment of SQL Select statement dealing with this column looks like this:
>>
>>

>>where TABLE.Field1  order by <someother>
>>

>>
>>When executing this SQLSelect against SQL Server the error says:
>>
>>"Non-boolean type specified in context where a condition is expected, new 'order'"
>>
>>Do I understand that - for SQL Server backend - I must modify the SQL Select to have this column as TABLE.Field1 = 1 ?
>>
>>TIA.
>
>yes.

You can also do

where Table.Field1 = 'true'