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 |
Hansen |
Ola |
Timoteivn 10 |
Sandnes |
| 2 |
Svendson |
Tove |
Borgvn 23 |
Sandnes |
| 3 |
Pettersen |
Kari |
Storgt 20 |
Stavanger |
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:
Click here to design a Stunning Flash Website for Free
Wix is a revolutionary web design tool that provides anyone with the possibility to create professional and beautiful websites for free.
With e-commerce features, search engine visibility and many more professional tools, Wix is the ultimate solution for creating a spectacular site while saving tons of money.
| 
