>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

Don't enter values manually in SSMS. Use UPDATE command or INSERT command.

Varchar(max) is the correct type to use.