>Aleksey
>
>Thank you so much. It seems I have to convert the datatype in SQL Server, giving up using 'bit' and switching to Integer. I have to keep mssql and mysql database synchronized, so I think that's the way.
>
>Thanks again.
>

Hi Grigore,

There is no need to change the table schema, you can simply use CAST or CONVERT functions in your SELECT statement.

Thanks,
Aleksey.

>
>>
>>Take a look into "Data Type Conversion Control" topic in VFP8 help. It says that you can not do this on VFP side, but you can force SQL Server to return integer field by performing conversion on its side.
>>
>>>I can't post a repro code, because I did all those things in Command window.
>>>
>>It is not like I still need a repro. But, doesn't copy/paste works in Command window?
>>
>>Thanks,
>>Aleksey.