Difference between revisions of "LEN/de"
From SQLZOO
< LEN
(Created page with "Category:Deutsch <table align='right' border='1'> <caption>Kompatibilität</caption> <tr><th colspan='3'>LEN</th></tr> <tr><td align='center'>'''DBMS'''</td><td align='cen...") |
|||
| Line 15: | Line 15: | ||
<p></p> | <p></p> | ||
<pre style='width:60ex'> | <pre style='width:60ex'> | ||
| − | LEN(' | + | LEN('Hallo') -> 5 |
</pre> | </pre> | ||
Latest revision as of 11:48, 28 October 2012
| LEN | ||
|---|---|---|
| DBMS | OK | Alternative |
| Ingres | Nein | LENGTH(S) |
| MySQL | Nein | LENGTH(S) |
| Oracle | Nein | LENGTH(S) |
| PostgreSQL | Nein | LENGTH(S) |
| SQL Server | Ja | LEN(s) |
LEN
LEN(s) liefert die Anzahl der Zeichen in der Zeichenkette (String) s.
LEN('Hallo') -> 5
SELECT LEN(name), name FROM bbc
SELECT LENGTH(name), name FROM bbc
Siehe auch
| Sprache: | English • Deutsch |
|---|