quote:

---

Are you wanting this?

SELECT replace(replace(FieldA, '+', ''), '%2E', '.')

Looks like you want 4 outputs, if the above does not meet your needs...