Hello,

i've got a Oracle 8 database that contains a Varchar2(2000) field.
The field holds the definition for a Toolbar.

It looks like this :

---

Search Sample SEÿÿ Next Sample NSÿÿView SampleAuditSAUDIT RGÿþ View Notepad NOTEPAD RGÿÿ Print Screen PRÿÿPrevious Sample PSÿÿ

---

We switched to a new version of the program (terminal based to windows based) and we need to edit all the descriptions so they will fit on a button.

So 'Search Sample' would become 'Search' and 'Next Sample' would become 'Next'

Is it possible to do a Search-Replace in this database-field?

Regards,

Njit

Yes:

UPDATE t SET col = REPLACE(col,'Search Sample','Sample')
WHERE ...;

You can either repeat with other replacements, or nest them:

UPDATE t SET col = REPLACE(REPLACE(col,'Search Sample','Sample'),'Next Sample','Next')
WHERE ...;

Thank you very much Tony..

You have been most usefull (again)

Hi,
I had a similar situation that I wanted to updated my DB, for all the email addressess (internal and private), starting with gggg, and replace the emails with xxx.
I had to do that manually.

update wm_order set email = replace(email,'gggg','xxx');

Instead of only 3 applicable records, it is updating all the records.
I would appreciate your help.

Thanx and Regards
Aruneesh

Some sort of WHERE clause would seem appropriate.