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
(1500 characters remaining)
Thank you for your feedback