Difference between revisions of "LEN"

From SQLZOO
Jump to navigation Jump to search
 
(One intermediate revision by one other user not shown)
Line 9: Line 9:
<tr><td align='left'>sqlserver</td><td>Yes</td><td>LEN(s)</td></tr>
<tr><td align='left'>sqlserver</td><td>Yes</td><td>LEN(s)</td></tr>
</table>
</table>
<h1>LEN</h1>
<h1>LEN</h1>
<p>LEN(s) returns the number of characters in string s. </p>
<p>LEN(s) returns the number of characters in string s. </p>
Line 29: Line 30:
<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>
{{Languages}}

Latest revision as of 10:41, 28 October 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

Language:Project:Language policy English  • Deutsch