>>>>>Interesting that I started with VFP/SQL using SPT and now moving to VFP/SQL using CA. Am I going in the wrong direction? :)
>>>>
>>>>No. I think using CA is a good approach and gives more flexibility /ease to write code.
>>>
>>>If I may ask you a question, please, on VFP SPT (since you are in this mode of work). When you get a column from SQL Server of type VARCHAR(MAX) using SPT is the type of this column in VFP Char (255) or Memo?
>>
>>We're supporting SQL 2000, so no varchar(max) fields. I was trying to change one of the tables to use varchar(max), but got an error about default value. Will try anyway.
>
>Thank you.

I think I remember from Sergey's response, that ODBC driver correctly converts varchar(max) fields to Memo, but has other problems (and not recognizes new types in VFP - we don't use them).