12. 6. 1. LEFT function returns a number of characters from the left-hand side of a string.
This can be from 1 character up to all the characters in the string.
5>
6> DECLARE @LEFT_STRING char(100)
7> SET @LEFT_STRING = "www.java2java.com, www.java2java.com, java2s"
8> SELECT LEFT(@LEFT_STRING,10)
9> GO
--------------------
www.java2s
(1 rows affected)
12. 6. LEFT
12. 6. 1.
LEFT function returns a number of characters from the left-hand side of a string.