Getting Character Count in MS SQL

32 Reads 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')

The result returns 7..

SELECT LEN(' develop')

The result returns 8..

SELECT LEN('develop ')

The result returns 7..

SELECT LEN(' develop ')

The result returns 8..

Ms Sql