Returns the length of a string value.

Syntax

---

CHARACTER_LENGTH(<StringExpression>)
CHAR_LENGTH(<StringExpression>)

<StringExpression> = 

Type of:

CHARACTER|CHAR
CHARACTER VARYING|VARCHAR
GUID
CHARACTER LARGE OBJECT|CLOB

Returns

---

INTEGER

Usage

---

The CHAR_LENGTH function returns the length of a string value as an integer value.

Examples

---

SELECT Notes, CHAR_LENGTH(Notes) AS NumChars
FROM Customers

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: