Revision as of 10:32, 16 July 2012

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

@@ Line 9: / Line 9: @@
 <tr><td align='left'>sqlserver</td><td>Yes</td><td>LEN(s)</td></tr>
 </table>
-<h1>LENGTH</h1>
+<h1>LEN</h1>
 <p>LEN(s) returns the number of characters in string s. </p>
 <p></p>