====== LENGTH Function - PL/HQL Reference======

LENGTH function returns the length of the specified string expression in characters.

**Syntax**:

<code language="sql">
LENGTH(string_expression); 
</code>

**Return Data Type:**

STRING

**Example:**

<code language="sql">
LENGTH('Abc ');
---
4
</code> 

**Compatibility**: Oracle, IBM DB2, Teradata, PostgreSQL, MySQL and Netezza

**Version**: PL/HQL 0.03

See also:
  * [[len|LEN]]