>>what type shall i use in QLserver2008 for VFP memo fields i tried varchar(MAX) but it does not seem to accept carriage returns when entered in SSMS
>>
>>
>>Peter
>
>
>It accepts all chars, just do not shows them in SSMS.
>And n/varchar(max) is the right type to use.

You can not insert CR if you try to edit top 200 rows in SSMS. (Not that I ever use it).