Hi Sean,
Take a look at the StrTran() function
>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
>
>-Julius Caesar
kenweber
GCom2 Solutions
Microsoft Certified Professional