Remove spaces in string in Teradata

oreplace function can be used to replace any character in a string.

Below example replaces space with empty character, all the spaces are removed in the string.

SELECT oreplace ('aahhaa',' ','');


To remove spaces in particular table on a column, following code can be used

SELECT oreplace (student_name,' ','') from student