Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

LEN (Transact-SQL)

Returns the number of characters of the specified string expression, excluding trailing blanks.

ms190329.note(en-US,SQL.90).gifNote:
To return the number of bytes used to represent an expression, use the DATALENGTH function.

Topic link icon Transact-SQL Syntax Conventions


LEN ( string_expression )

string_expression

Is the string expression to be evaluated.

bigint if expression is of the varchar(max), nvarchar(max) or varbinary(max) data types; otherwise, int.

The following example selects the number of characters and the data in FirstName for people located in Australia.

USE AdventureWorks;
GO
SELECT LEN(FirstName) AS Length, FirstName, LastName 
FROM Sales.vIndividualCustomer
WHERE CountryRegionName = 'Australia';
GO

Community Additions

ADD
Show:
© 2015 Microsoft