Getting Character Count in MS SQL
In Ms Sql, LEN() function is used to get the number of characters of a string type data (char, varchar..).
The name of the LEN() function comes from "length".
The LEN function includes leading spaces in the string, but not trailing spaces.
Let's examine the examples below...
SELECT LEN('develop')
SELECT LEN(' develop')
SELECT LEN('develop ')
SELECT LEN(' develop ')