>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.