LEN

Compatibility

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  

1.

SELECT LEN(name), name
  FROM bbc

SELECT LENGTH(name), name
  FROM bbc

SELECT LENGTH(name), name FROM bbc Submit SQLrestore default

result

See also

• SUBSTRING function
• (concatenate) function

Language:Project:Language policy	English  • Deutsch