select LEFT('SQL Server', 3) : LEFT « String Functions « SQL Server / T-SQL Tutorial






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

---
SQL

(1 rows affected)
1>








12.6.LEFT
12.6.1.LEFT function returns a number of characters from the left-hand side of a string.
12.6.2.select LEFT('SQL Server', 3)
12.6.3.Taking the Leftmost or Rightmost Part of a String
12.6.4.A SELECT statement that uses the LEFT function
12.6.5.Use LEFT and RIGHT to get sub value from a column
12.6.6.LEFT(CompanyName, 1) and like
12.6.7.How to use the string functions to parse a string