Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread How to replace characters using SQL?
Tue, May 1 2007 5:48 PMPermanent Link

Dave Harrison
In DBISAM 4.x, is there an easy SQL solution to replacing all occurances
of "abc" with "def" in a memo? Or do I have to use a table and go
through the table in a loop? Of course, I don't want to lose the rest of
the text in the memo. I need it to work like a Replace command in a text
editor so it preserves the rest of the text.

TIA
Dave
Tue, May 1 2007 6:14 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Dave,

<< In DBISAM 4.x, is there an easy SQL solution to replacing all occurances
of "abc" with "def" in a memo? Or do I have to use a table and go  through
the table in a loop? Of course, I don't want to lose the rest of the text in
the memo. I need it to work like a Replace command in a text editor so it
preserves the rest of the text. >>

Yep, see the REPLACE function:

http://www.elevatesoft.com/dbisam4d7_functions.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

Image