The carriage return has code 13 and the line feed - 10.
REPLACE memofield WITH STRTRAN(memofield, CHR(13)+CHR(10), "")
>Hi
>
>What is the correct syntax for removing carriage return and line feed from a memo field.
>
>Replace memofield with strtran(memofield,?,"") where ? is the bit I can't remember.
>
>Thanks
>
>Colin
--sb--