This documentation is archived and is not being maintained.

DATALENGTH (SQL Server Compact Edition)

Returns the number of bytes used to represent any expression.

DATALENGTH ( expression ) 


Is an expression of any data type.

The following example returns the DATALENGTH of each company name listed in the Customers table in the Northwind database.

SELECT DATALENGTH(CompanyName), CompanyName
FROM Customers