LENGTH

Syntax

LENGTH(string_expr)

LENGTH returns the number of characters of the giving string expression.

Example

This example returns the company name and the number of characters in the name for each company.

SELECT CompanyName, LENGTH(CompanyName)
FROM CUSTOMERS

Here is the result set:

CompanyName
_______________________________
Consolidated Holdings 21
Eastern Connection 18
France restauration 19
Great Lakes Food Market 23
Island Trading 14
Let's Stop N Shop 17

Equivalents in other databases

TABLE 71. Equivalents in other databases

IBM DB2	LENGTH function
Microsoft SQL Server	LEN function