DATALENGTH (SQL Server Compact)

Returns the number of bytes used to represent any expression.

Syntax

DATALENGTH ( expression ) 

Arguments

  • expression
    Is an expression of any data type.

Return Value

int

Example

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