Returns the number of characters of the specified string expression, excluding trailing blanks.
|To return the number of bytes used to represent an expression, use the DATALENGTH function.|
The following example selects the number of characters and the data in
FirstName for people located in
USE AdventureWorks; GO SELECT LEN(FirstName) AS Length, FirstName, LastName FROM Sales.vIndividualCustomer WHERE CountryRegionName = 'Australia'; GO