>Hello All,
>
> I have solved my many DB connectivity problems and was wondering what function I would use to locate a character in a field and replace it with something else ie make smith,charles smith charles or something like that. TIA
>
>
>It is easier to find men who will volunteer to die, than to find those who are willing to endure pain with patience
>

STRTRAN() will look for a specific character expression in a string and substitute another string for it. For example:

? STRTRAN('This is a test string',' is',' was') && This was a test string

CHRTRAN() will repace on character in a compare string with the equivalent character in a substitution string:

? CHRTRAN('123456789','1357','ABCD') && A2B4C6D89


>-Julius Caesar