>>>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 :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.