trim

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

trim [2015/09/23 20:27] (current)
Line 1: Line 1:
 +====== TRIM Function - PL/HQL Reference======
 +
 +TRIM function removes leading and trailing characters from a string.
 +
 +**Syntax**:
 +
 +<code language="​sql">​
 +TRIM(string_expression); ​
 +</​code>​
 +
 +**Return Type:**
 +
 +STRING
 +
 +**Example 1:**
 +
 +<code language="​sql">​
 +'#'​ || TRIM(' Hello ') || '#'; ​
 +--
 +#Hello#
 +</​code> ​
 +
 +**Compatibility**:​ Oracle, IBM DB2, Teradata, Microsoft SQL Server, PostgreSQL, MySQL and Netezza
 +
 +**Version**:​ PL/HQL 0.03
 +