>does anyone know how to get rid of carriage returns in a memo field?
>This doesnt work.
>lcmemoval=table1.memofld
>lcnewval=strtran(lcmemoval,Chr(13))
>
You need to replace both the CHR(13) and CHR(10) characters:
REPLACE Table1.Memo WITH STRTRAN(STRTRAN(table1.memo,CHR(13),''),CHR(10),'')