Teradata - Trim Leading and Trailing blank spaces

Suppose the data is stored as below in one of the columns of a table

We can Trim Leading and Trailing blank spaces in a column by using the below funcition Select Distinct TRIM(BOTH ' ' FROM ColumnName) from DatabaseName.TableName;