> We decided to go with numerics for "logical" fields, instead of dealing with the differences between VFP logical type and SS bit type.

The differences are very easily handled if you let the VFP engine do it. Create a variable named TRUE, set it to .T. Anytime that you want to pass it to SQL Server, do it as a parameter:

SELECT ... FROM ... WHERE column = ?TRUE

The database engine (VFP's) and ODBC will handle the conversion for you.


>In SS we decided on numeric(1,0) as the datatype rather than integer to just store 1 instead of 4. Not really an issue, but the client had a hangup about disk space.

You could have used a TinyInt. It has a size of one byte.

I can't explain the behavior that you're seeing, sorry.

-Mike