![]() ![]() ![]() |
Ispirer SQLWays Database Migration Software
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 17Equivalents in other databases
![]() ![]() ![]() |