>Hi Sean,
>
>>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
>
>You have two choices, CHRTRAN() and STRTRAN().
>
>Chrtran() is faster because it only does searches for one character:
>
Actually, I believe that Dave Frankenbach found this not to be the case recently; the time on STRTRAN() was ~O(n) whereas CHRTRAN() ~O(n^2) on performing substitutions.
>
lcText = chrtran('smith, charles', ',', '')
>
>returns "smith charles". It also replaces
every found occurenece:
>
>
lcText = chrtran('s,m,i,th, charles', ',', '')
>
>also returns "smith charles"
>
>Strtran() can find and replace whole strings with whole strings, look in the help for more info.