>I'm slowly moving some data from VFP tables to SQL Server tables. The table I'm working on at the moment, has a logical field in it. How do I represent a logical in SQL Server? I assume I will need to do a DBSETPROP on the view field and change it's datatype to logical. Hope that makes sense.
>

Red,
In SQL Server, use the Bit field. You won't need to do anything. The ODBC driver will convert logical to bit and back again.

HTH.