Latest

recent

SQL LEN() Function

The LEN() Function

The LEN() function returns the length of the value in a text field.

SQL LEN() Syntax

SELECT LEN(column_name) FROM table_name


SQL LEN() Example

We have the following "Persons" table:

P_Id LastName FirstName Address City
1 Potter Harry Stocks55 Tokyo
2 Davidson Harley Elvin23 Jayanagar
3 Check Peter Marcelo Beijieng

Now we want to select the length of the values in the "Address" column above.
We use the following SELECT statement:

SELECT LEN(Address) as LengthOfAddress FROM Persons

The result-set will look like this:

LengthOfAddress
8
7
6
SQL LEN() Function Reviewed by 1000sourcecodes on 01:11 Rating: 5
Powered by Blogger.