TechNet
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize
The document is archived and information here might be outdated

DATALENGTH (SQL Server Compact Edition)

Returns the number of bytes used to represent any expression.


DATALENGTH ( expression ) 

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
Show:
© 2016 Microsoft