2012-02-29

Teradata - String trimming


select
      TRIM(
            LEADING
            ' '
            FROM
                  TRIM( TRAILING ' ' FROM FIELD_NAME_HERE )
      )
from
      TABLE_NAME_HERE
;

No comments:

Post a Comment