====== LEN Function - PL/HQL Reference======

LEN function returns the length of the specified string expression in characters, **excluding** the trailing blanks.

**Syntax**:

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

**Return Data Type:**

STRING

**Example:**

<code language="sql">
LEN('Abc ');
---
3
</code> 

**Compatibility**: Microsoft SQL Server

**Version**: PL/HQL 0.03

See also:
  * [[length|LENGTH]]