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([Company Name]) AS Expr1, [Company Name]
(1500 characters remaining)
Thank you for your feedback