Export (0) Print
Expand All
Expand Minimize

DATALENGTH (Transact-SQL)

Returns the number of bytes used to represent any expression.

Topic link iconTransact-SQL Syntax Conventions


DATALENGTH (expression )

expression

Is an expression of any data type.

bigint if expression is of the varchar(max), nvarchar(max) or varbinary(max) data types; otherwise int.

DATALENGTH is especially useful with varchar, varbinary, text, image, nvarchar, and ntext data types because these data types can store variable-length data.

The DATALENGTH of NULL is NULL.

NoteNote

Compatibility levels can affect return values. For more information about compatibility levels, see ALTER DATABASE Compatibility Level (Transact-SQL).

The following example finds the length of the Name column in the Product table.

USE AdventureWorks;
GO
SELECT length = DATALENGTH(Name), Name
FROM Production.Product
ORDER BY Name;
GO
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft