Navigation

	Home Page
	Index
	All Pages

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

create function dbo.PadLeft
    (
     @input     int 
    ,@width     int 
    ,@pad       char(1) 
    ) returns varchar as begin
/*
declare
     @input int = 10000
    ,@width int = 5 
    ,@pad char(1) = '0'   
*/    
return REPLICATE(@pad, @width - ceiling(LOG10(@input+1))) + CONVERT(varchar(20), @input)

end