LEN

Syntax

LEN(string_expr)

LEN returns the number of characters of the giving string expression, excluding trailing blanks.

Example

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

SELECT CompanyName, LEN(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 83. Equivalents in other databases

IBM DB2	LENGTH function
Oracle	LENGTH function