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 "