|
Ispirer SQLWays Database Migration Software
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 17Equivalents in other databases