Home Forums Article Discussions Article Discussions by Author Discuss content posted by Joshua A. Walker Function to Add Leading 0's (Zeros) to an INT RE: Function to Add Leading 0's (Zeros) to an INT

  • March 5, 2009 at 7:46 am

    #954038

    I use the power function to accomplish this task.

    SELECT RIGHT(power(10,@TotalLength) + @myInt,@TotalLength)

    I did use

    SELECT RIGHT(Convert(varchar,(power(10,@TotalLength) + @myInt)),@TotalLength)

    but found that I could eliminate the convert function from the statement.

    Thanks

    Todd P Payne