Difference between revisions of "LENGTH"

From SQLZOO
Jump to: navigation, search
 
Line 9: Line 9:
 
<tr><td align='left'>sqlserver</td><td>No</td><td>[[LEN |LEN(s)]]</td></tr>
 
<tr><td align='left'>sqlserver</td><td>No</td><td>[[LEN |LEN(s)]]</td></tr>
 
</table>
 
</table>
 +
 
<h1>LENGTH</h1>
 
<h1>LENGTH</h1>
 
<p>LENGTH(s) returns the number of characters in string s. </p>
 
<p>LENGTH(s) returns the number of characters in string s. </p>
Line 32: Line 33:
 
   <li>[[CONCAT |(concatenate) function]]</li>
 
   <li>[[CONCAT |(concatenate) function]]</li>
 
</ul>
 
</ul>
 +
 +
{{Languages}}

Latest revision as of 11:44, 28 October 2012

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: English  • Deutsch
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense