Replacing 1 character w/another in a string 1

[rtipton12]

Hello all.

Is there a way to replace 1 character with another in a field? (ex: replace a " with a - ). I am trying to copy query results from Query Analyzer into an Excel file and one of the fields has a double quote (&quot in it and it is throwing my paste into Excel off.

I would like to find something similar to the STRTRAN() function in Visual FoxPro.

Any help is appreciated.

Rt

 

[JayKusch]

replace(FieldName,'a','-')

Thanks

J. Kusch

 

[rtipton12]

Thanks. I will try that.

Rt