You could REPLACE ALL MyMemo WITH CHRTRAN(MyMemo,CHR(13),CHR(253).
>Can someone tell me how to search through a memo field to find any occurrences of CHR(13) and then replace it with another value, say CHR(253)? I'm trying to export the contents of a DBF which contains memo fields to a fixed length SDF file. Since many of the records contain hard returns in the memo field, exporting to an SDF file actually creates multiple records after each hard return.
>
>Thanks in advance!
>
>Patrick Kirkman