====== 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