DATALENGTH(@Value) : DATALENGTH « String Functions « SQL Server / T-SQL






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

DATALENGTH(@Value)


1> DECLARE @Value nVarChar(20)
2> SET @Value = 'abc'
3>
4> SELECT DATALENGTH(@Value)
5> GO

-----------
          6

(1 rows affected)
1>








Related examples in the same category

1.DATALENGTH(): returns the number of bytes used to manage a value
2.DATALENGTH() for for Unicode character set