DATALENGTH( expression )

UNSIGNED INT

The return values of the DATALENGTH function are as follows:

This function supports NCHAR inputs and outputs.

The following statement returns the length of the longest string in the CompanyName column.

SELECT MAX( DATALENGTH( CompanyName ) )
FROM Customers;

The following statement returns the length of the string '8sdofinsv8s7a7s7gehe4h':

SELECT DATALENGTH( '8sdofinsv8s7a7s7gehe4h' );