wonderful, that fixed my problem. Im not sure why when I tried the following it failed. Again, thans a bunch

replace(string_pct, '%', ' ')

Much appreciated. This is a corporate environment and you know how sloppy some coders can be.

Thanks for the info

I am so sorry for having wasted anyone's time. I have found exactly what I am looking for. I had searched before adding my post but did not discover...