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
