Export (0) Print
Expand All
Expand Minimize

Returns the number of bytes used to represent any expression.



DATALENGTH ( expression ) 

expression

Is an expression of any data type.


int

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

SELECT DATALENGTH([Company Name]) AS Expr1, [Company Name]
FROM Customers
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft