Hi I an trying to convert a Note field to Varchar for a form. I tried searching old emails but can't find the answer.
My LineEnd character is a ^, If I use Alter Table to change it to Varchar the blank lines change to ^. I tried SRPL using (Char(13)) and even 10 but (Char(13)) shows up in the form instead of a blank line or CR. I put a Rich Edit and DB Memo on the form to see what happens. As soon as I double click in the Rich Edit hit CR for a blank line between paragraphs, save it the DB Memo field shows /par. So I tried SRPL using /par and of course that shows up in the form This seems so easy but had my stumped, I guess I really do not understand the inner workings of Varchar and that is why I am stuck. Thanks Marc
