len

Differences

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

Link to this comparison view

len [2015/09/23 20:27] (current)
Line 1: Line 1:
 +====== 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]]