LEN
From SQLZoo
LEN | ||
---|---|---|
Engine | OK | Alternative |
ingres | No | LENGTH(S) |
mysql | No | LENGTH(S) |
oracle | No | LENGTH(S) |
postgres | No | LENGTH(S) |
sqlserver | Yes | LEN(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: | English • Deutsch |
---|