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

My thoughts was about varchar not about SSMS :-)