What is LEN in Transact-SQL? It will returns the number of characters of the specified string expression, excluding trailing blanks.

For example,

DECLARE @temp varchar(60);
SET @temp = ‘ABCDEF ‘;
SELECT LEN(@temp);

The returned result is ‘6′. It returns the count of 6 characters “ABCDEF”.

Tags: Transact-SQL