On Jul 23, 2007, at 9:50 AM, [EMAIL PROTECTED] wrote:
fieldname=regexp_replace(fieldname,old_sub_string,new_sub_string)
Add a 'g' flag:
fieldname=regexp_replace(fieldname,old_sub_string,new_sub_string, 'g')
From the end of a paragraph in 9.7.3 just before 9.7.3.1:
The flags parameter is an optional text string containing zero or
more single-letter flags that change the
function’s behavior. Flag i specifies case-insensitive matching,
while flag g specifies replacement of each
matching substring rather than only the first one.
Perry Smith ( [EMAIL PROTECTED] )
Ease Software, Inc. ( http://www.easesoftware.com )
Low cost SATA Disk Systems for IBMs p5, pSeries, and RS/6000 AIX systems
