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






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

LEN(@Value)


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

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

(1 rows affected)
1>








Related examples in the same category

1.LEN: Returns the length of a string as an integer
2.LEN(): returns the length of a string as an integer
3.REPLICATE('*', 20 - LEN(Name))