x

SQL – LEN()

Prev     Next

SQL LEN() function returns the total length of the given column. Syntax for SQL LEN() function is given below.


SQL Syntax for LEN() function:

Syntax for LEN() function in SQL SELECT LEN(column_name) FROM table_name;

Please consider the following table with few records as given below.

Table name (for example): student
Column names in this table: Student_ID, Student_name, City and Marks
Available records: 4 rows