>>>>What is the equivalent of :
>>>>select .f. as f_logic, af1, af2 from myTable
>>>>
>>>>in sqlexce
>>>>
>>>>sqlexec(nhandle," select .f. as f_logic, af1, af2 from myTable ", "ccur")
>>>
>>>It should work for VFP ODBC driver. What backend database are you running against?
>>
>>sqlExpress 8.
>>Chuck Mautz answer it
>>thanks
>
>MS SQL Server does not have logical data type. A bit is numeric data type. It works in this case because VFP maps the bit data type to VFP logical field.

Thans Sergey,
I am Upsizing an application from VFP Data to MSSQL.
It is the first time I am doing that and I have a lot of questions - problems. So far I am doing rather well.