SQL LEN() Function

SQL LEN() Function

LEN() - The LEN() function used to returns the length of text field.
The syntax of LEN() is :

sql len() function

How to use SQL LEN() Function.

Let’s understand LEN() function with an example :

We have SQL Table StudentMst with below column.

SELECT * FROM StudentMst

ID Name City Pincode Mobile
1 Meera Bombay 380022 7874555555
2 Rahul Surat 352200 7874444444
3 Jayesh Ahmedabad 352200 7874333333
4 Dhvanish Bombay 380022 7874111111
5 Reena Baroda 352222 7874666666
6 Veera Baroda 352222 7874121212

SELECT LEN(Name) AS Name,LEN(City) AS City FROM StudentMst

Name City
5 6
5 5
6 9
8 6
5 6
5 6

Leave a Reply

Your email address will not be published. Required fields are marked *

2 + 5 =


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">