select LEN(' SQL Server ') (space at both ends) : LEN « String Functions « SQL Server / T-SQL Tutorial






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

-----------
         11

(1 rows affected)








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