A. By converting to a string and padding that way. e.g. an example from pubs to pad a value :-
select right(replicate('0',10)+ convert(varchar(10),ytd_sales),10) from titles
1 comment
Hide comments
A. By converting to a string and padding that way. e.g. an example from pubs to pad a value :-
select right(replicate('0',10)+ convert(varchar(10),ytd_sales),10) from titles