how to replace a character by its ascii in SQL SELECT statement in Oracle

The database we are using which we only have reading access has a character that is shown as a square, it has the ascii code of 26 or x1A in hex and i want to replace it 开发者_如何转开发in the SELECT statement to another character using its ascii only.

We are using Oracle 10g.

Is there a way? Maybe using Regular Expressions?

Thank you,,,

---

You can use use the REPLACE function:

SELECT REPLACE(text,CHR(26),otherChar) FROM .........