techmixing.com
LEFT() function in SQL Server - Technology with Vivek Johari
This article tells about the LEFT() function in SQL Server.