Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

Removing any character in a string or column in Teradata

  1. Forget Code
  2. Teradata
  3. Removing any character in a string or column
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$$