Example - Analytics Database - Teradata Vantage

The following statement trims trailing SEMICOLON characters from the specified string.

   SELECT TRIM( TRAILING ';' FROM textfield) FROM texttable;