LENGTH

Syntax

LENGTH(expression)

The LENGTH function returns the length of a value. The argument can be an expression that returns a value of any built-in data type.

If the argument is a string, the function returns the number of characters in the string. The length of fixed-length strings includes blanks. The length of a varying-length string is the actual length, not the maximum length.

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 67. Equivalents in other databases

Oracle	LENGTH function
Microsoft SQL Server	LEN function