On Wed, Jun 1, 2011 at 10:22 AM, Geoffrey Myers <lists@xxxxxxxxxxxxxxxxxxxxx> wrote:
Rick GenterI want to use regex_replace() to replace characters in multiple records.
What I would like to do is this:
select regex_replace((select fname from table), 'z', 'Z'));
The problem is, the subquery returns more then one row.
So, is there a way to do what I'm trying to do? That is, replace the same character in multiple records using regex_replace() ?
I think what you want is:
SELECT regex_replace(fname, 'z', 'Z') FROM table;
This should return a recordset where each row has one column which is the result of regex_replace() on the corresponding row of table.
--
rick.genter@xxxxxxxxx
