Difference between revisions of "LEN"

From SQLZOO
Jump to navigation Jump to search
Line 29: Line 29:
 
<p>See also</p>
 
<p>See also</p>
 
<ul>
 
<ul>
−
   <li>[[SUBSTRING function]]</li>
+
   <li>[[SUBSTRING |SUBSTRING function]]</li>
−
   <li>[[(concatenate) function]]</li>
+
   <li>[[CONCAT |(concatenate) function]]</li>
 
</ul>
 
</ul>

Revision as of 15:05, 16 July 2012

Compatibility
LEN
EngineOKAlternative
ingresNoLENGTH(S)
mysqlNoLENGTH(S)
oracleNoLENGTH(S)
postgresNoLENGTH(S)
sqlserverYesLEN(s)

LEN

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

    LEN('Hello') -> 5  

SELECT LEN(name), name
  FROM bbc

SELECT LENGTH(name), name
  FROM bbc

See also

Retrieved from "http://sqlzoo.net/w/index.php?title=LEN&oldid=1374"