Removing any character in a string or column in Teradata

You can remove/replace any character in a string or column by using oreplace.

Examples:
To remove the character 'a' in the string 'aahhaa'
SELECT oreplace ('aahhaa','a','');

Output:
hh


To replace the character 'a' with another character say '$'
SELECT oreplace('aahhaa','a','$')

Output:
$$hh$$