Important Points About SQL Server LEN Function
- The LEN() function returns the number of characters in a given string expression, excluding any trailing spaces.
- It returns an INT data type, except for VARCHAR(max), NVARCHAR(max), or VARBINARY(max) which returns BIGINT.
- It includes Leading spaces in the length calculation, but not trailing spaces.
- If the input string is NULL, LEN() will return NULL.
- To include trailing spaces in the length calculation, use the DATALENGTH() function instead.
SQL Server LEN() Function
SQL SERVER LEN() function calculates the number of characters of an input string, excluding the trailing spaces.
Contact Us