S
Steve
I am trying to replace the ASCII square character for a carriage return in
several hundred rows. I would like to replace it with an actual carriage
return so the text will appear as a new line/paragraph. I put together this
SQL statement:
UPDATE MyTable SET MyField = Replace(MyField,Chr(13) & Chr(10),Chr(13))
WHERE ((InStr(MyField,Chr(13) & Chr(10))>0))
This is not making the changes that I am looking for. What is the correct
syntax to get my memo field to update?
several hundred rows. I would like to replace it with an actual carriage
return so the text will appear as a new line/paragraph. I put together this
SQL statement:
UPDATE MyTable SET MyField = Replace(MyField,Chr(13) & Chr(10),Chr(13))
WHERE ((InStr(MyField,Chr(13) & Chr(10))>0))
This is not making the changes that I am looking for. What is the correct
syntax to get my memo field to update?