>>Perhaps that is a driver problem, I use DRIVER=SQL Server Native Client 10.0.
>>
>>When I create a varchar(max) field the type shows as text:
>>
>>

>>ALTER TABLE TestTable ADD NewField varchar(max)
>>SP_Columns TestTable
>>

>>it shows:
>>

>>Type_Name = "test"
>>Precision =  2147483647
>>

>>
>>A query from VFP with the above mentioned driver shows a completely blank field, which I cannot open.
>>
>>When I copy to a table, it creates a character field with length 0!
>
>It's known VFP bug. The varchar(max) only works with SQL 2000 ODBC driver. You can use Text data type or use CA with ADO.

Do you know where I can download the SQL 2000 ODBC driver? or if there is another alternative for a driver that works for 32 and 64 bit OS?