DATALENGTH(): returns the number of bytes used to manage a value : DATALENGTH « String Functions « SQL Server / T-SQL

1. SQL Server / T-SQL
2. String Functions
3. DATALENGTH

DATALENGTH(): returns the number of bytes used to manage a value

1> -- DATALENGTH(): returns the number of bytes used to manage a value.
2>
3> DECLARE @Value VarChar(20)
4> SET @Value = 'abc'
5>
6> SELECT LEN(@Value)
7> GO

-----------
          3

(1 rows affected)
1>
           
       

Related examples in the same category