Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
How to replace characters using SQL? |
Tue, May 1 2007 5:48 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |