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