LEFT(): returns characters from the left-most part of the string, counting characters to the right : LEFT « String Functions « SQL Server / T-SQL






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

LEFT(): returns characters from the left-most part of the string, counting characters to the right


1> -- LEFT(): returns characters from the left-most part of the string, counting
2> -- characters to the right.
3>
4> DECLARE @FullName VarChar(25)
5> SET @FullName = 'George Washington'
6> SELECT LEFT(@FullName, 5)
7>
8> GO

-----
Georg

(1 rows affected)
1>








Related examples in the same category

1.LEFT: return a number of characters from the left-hand side of a string
2.Left: get string to the left
3.LEFT(Name,1)