select LEN('SQL Server') : LEN « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. LEN
2>
3> select LEN('SQL Server')
4> GO

-----------
         10

(1 rows affected)
1>








12.7.LEN
12.7.1.LEN Returns the length of a string as an integer.
12.7.2.select LEN('SQL Server')
12.7.3.select LEN(' SQL Server ') (space at both ends)
12.7.4.Determining the Number of Characters or Bytes in a String by using LEN