Tom,

Chrtran() does a 1 for 1 or 1 for none conversion of characters.

strtran() can change any substring to any number of other characters.

>I need to replace a single quote character in a string with two single quote characters so that Oracle will update correctly.
>CHRTRAN([O'BRIEN],['],['']) doesn't work... what will?