LENGTH

Compatibility

LENGTH
Engine	OK	Alternative
ingres	Yes
mysql	Yes
oracle	Yes
postgres	Yes
sqlserver	No	LEN(s)

LENGTH

LENGTH(s) returns the number of characters in string s.

    LENGTH('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