LEN
Returns the number of characters of the specified string expression, excluding trailing blanks.
Syntax
LEN ( string_expression )
Arguments
string_expression
Is the string expression to be evaluated. string_expression can be a constant, variable, or column of either character or binary data.
Return types
bigint if expressionToSearch is of the varchar(max), nvarchar(max), or varbinary(max) data types; otherwise an int.
Example
SELECT LEN('abcdefg');