>Thanks - that function got me looking in the right place. I ended up using CHRTRAN because it allowed me to replace multiple characters at once. I couldn't figure out (quickly) how to do that with STRTRAN.
>
>Thanks again,
>Doug
Based on Mark's answer:
newphone = TRANSFORM(CHRTRAN(oldphone, CHRTRAN(oldphone,"0123456789",""),""),"@R 999-999-9999")
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.