SQL Server implementation is similar to PadLeft functionality in C #

1  Use [Test]2 GO3 SETAnsi_nulls on4 GO5 SETQuoted_identifier on6 GO7 --@column represents a field or constant, @paddingChar represents a complement character, @len the number of complements, @returnStr8 Create function [dbo].[PadLeft](@column varchar( -),@paddingChar Char(1),@len int)9 Ten returns varchar( -) as One     begin A         Declare @returnStr varchar( -) -         Select @returnStr = IsNull(Replicate(@paddingChar,@len - Len(IsNull(@column,0))),"')+ @column -         return @returnStr the     End

SQL Server implementation is similar to PadLeft functionality in C #