Something like

REPLACE ALL fieldname WITH STRTRAN(fieldname, CHR(13)+CHR(10), SPACE(1))

>
>When using -
>ALTER TABLE tablename ALTER fieldname C(254)
>the memo data will be full of the Carriage Return symbols.
>What is the best way of getiing rid of these symbols.
>