LENGTH Function in SQL

The LENGTH function returns the number of characters in a string.

Syntax:

LENGTH(string)

• string: The input string whose length you want to find.

Example:

SELECT LENGTH('Hello World') AS length_value;

Result:

Notes:

• In some databases like MySQL, LENGTH() returns the length in bytes, which can differ for multibyte characters.

• To get the number of characters (not bytes), use CHAR_LENGTH() in MySQL.

• In SQL Server, the equivalent is LEN() function.

• In Oracle, use LENGTH() as well.

If you want examples for a specific database or related string functions, just ask!