>Hi - I am familiar with the memo field type in vfp - basically it accomodates any length of characters... I wondered - what is the equivalent in SQL Server 2000... do I use varchar and set length to 8000? > >Regards > >Chris
Varchar is limited to 256 characters. Use the TEXT datatype.