LENGTH

From SQLZOO
Revision as of 10:27, 16 July 2012 by Connor (Talk | contribs) (Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>LENGTH</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td>...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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