[SQL] regexp_replace usage

[chester c young]

column name in table bue has miscapitalized Mc names, eg, 'John Mcneil' instead of 'John McNeil'.

(this should be easy but) how do you construct the update query?

also, regexp_string( 'Mcneil', 'Mc(.*)', initcap('\\1') ) => 'neil' _not_ Neil' - is this correct?

---

All-new Yahoo! Mail - Fire up a more powerful email and get things done faster.