Returns the part of a character string starting at a specified number of characters from the left.
LEFT(character_expression, integer_expression)
varchar
Note Compatibility levels can affect return values. For more information about compatibility levels, see sp_dbcmptlevel.
This example returns the five leftmost characters of each book title.
USE pubs
GO
SELECT LEFT(title, 5)
FROM titles
ORDER BY title_id
GO
Here is the result set:
-----
The B
Cooki
You C
Strai
Silic
The G
The P
But I
Secre
Net E
Compu
Is An
Life
Prolo
Emoti
Onion
Fifty
Sushi
(18 row(s) affected)
This example uses LEFT to return the two leftmost characters of the character string abcdefg.
SELECT LEFT('abcdefg',2)
GO
Here is the result set:
--
ab
(1 row(s) affected)
Data Types | String Functions |