Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How to find the length of a string in SQL Server?

Ashutosh Kumar Verma 954 16 Nov 2021

Ashutosh Kumar Verma

Jr software developer trainee

Myself Ashutosh Kumar Verma from Varanasi. I am a Software Developer in MindStick Software pvt. ltd. Prayagraj. I have completed my MCA from VBSP. University, Jaunpur in 2021.

1 Answers

Ashutosh Kumar Verma 16 Nov 2021

SQL LEN():

SQL LEN() function is used to find the length of any string. It accept a string and returns the length of that string.

Example:

SELECT LEN('MindStick');

output:

9

Find length of any number.

SELECT LEN(78965412532564);

Output:

14

MindStick Training