SQL Server Transact Basic to Expert - Using String Function Get Left most n values
This blog shows how to get the first n values starting count from the left most character using LEFT function in SQL
Example:
SELECT LEFT('this is a sample for the LEFT function', 10)
The expected result would be "'this is a "