Carmel,
This should work. You're probably confused because you don't see the result on the screen with the ? command. Try the following:
CREATE CURSOR test (mTest M)
INSERT INTO Test VALUES("1|2|3|4")
lcCrLf = CHR(13)+CHR(10)
REPLACE mTest WITH CHRTRAN(mTest, "|", lcCrLf)
HTH
>Hi,
>
>I am trying to remove the | symbol from an address and insert
>a carriage return instead to make the address 2 lines instead of 1.
>The carriage return is not getting inserted.
>Instead line 1 gets overwritten with line 2
>This is my code
>
>lf=+chr(13)+chr(10)
>? chrtran(ad1street,"|",+lf)
>
>where ad1street is a memo field.
>
>Thanks in advance
>Carmel
Daniel