Teradata - String trimming

select

      TRIM(

            LEADING

            ' '

            FROM

                  TRIM( TRAILING ' ' FROM FIELD_NAME_HERE )

      )

from

      TABLE_NAME_HERE

;