Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
April 8, 1999
A. By converting to a string and padding that way. e.g. an examplefrom pubs to pad a value :-
select right(replicate('0',10)+convert(varchar(10),ytd_sales),10) from titles
You May Also Like