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 "