LENGTH

From SQLZOO
Revision as of 16:06, 16 July 2012 by Connor (Talk | contribs)

Jump to: navigation, 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

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense