Replacing a string in a column using oreplace in Teradata

In a particular column, you can replace certain characters/string using oreplace.

Syntax:
SELECT oreplace(column_name, 'string_to_replace','new_string');


Example:
Consider a column of a table like this:
Role
Ex-Minister
Ex-Chairman
Ex-Member

SELECT oreplace(Role,'EX-','');

Output: (Replacing 'Ex-' with empty string)
Role
Minister
Chairman
Member