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