There is a function named LEFT in MS SQL Server which returns the left part of a character string with the specified number of characters.
Syntax:
LEFT ( string , No_of_Character )
Example:
SELECT LEFT(‘The quick brown fox jumps over a little lazy dog.’, 19)
Output:
The quick brown fox
