CONVERT function in SQL Server
the convert function in sql server allows you to convert an expression to any desired data type but can follow a certain format (especially for the date data type).
Tags : mssql functions
LEFT function in SQL Server
the left function in sql server allows you to extract a substring from a large string, starting from the leftmost character.