Sometimes you may need to pad character in left or in right in MS SQL Server. There is no direct function in MS SQL Server...