>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
As Naomi said - Varchar(MAX) is the correct replacement. No more Memo Field Missing/invalids!
SSMS direct record editing is OK for a quick fix, but I would not be using it for entering lengthy data if at all possible.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________