LENGTH

From SQLZOO
Jump to navigation Jump to search
Compatibility
LENGTH
EngineOKAlternative
ingresYes
mysqlYes
oracleYes
postgresYes
sqlserverNoLEN(s)

LENGTH

LENGTH(s) returns the number of characters in string s.

    LENGTH('Hello') -> 5 
SELECT LEN(name), name
  FROM bbc
SELECT LENGTH(name), name
  FROM bbc

See also

Language:Project:Language policy English  • Deutsch