In Sql Server we can use the LEN() function to get the length of a string. This function returns the number of characters in a string except the trailing spaces, but it includes the leading spaces.
[ALSO READ] Difference between Len() and Datalength() functions in Sql ServerSyntax
LEN(string)
Return Type
This function returns an INT representing the number of characters in a string. In case the input string is VARCHAR(MAX), NVARCHAR(MAX) or VARBINARY(MAX), it returns BIGINT.
Let us understand this function with examples:
Example 1: Get the Length of a string
SELECT LEN('Basav')
RESULT:
5
Example 2: Trailing space at the end of a string are ignored.
SELECT LEN('Basav ')
RESULT:
5
Example 3: Leading space at the beginning of a string are counted.
SELECT LEN(' Basav')
RESULT:
6
Example 4: Spaces in the middle of a string are counted.
SELECT LEN('A & B')
RESULT:
5
Example 5: Length of NULL.
SELECT LEN(NULL)
RESULT:
NULL
Awesome
Awesome
Awesome
Teaching is an art and need dedication and focus
Thanks for educating the community and
Appreciate your volunteership
Keep posting to resolve or solve simple to critical and hard problems on SQL
I have seen your posts, I like it and love it