function to pad a string with '-' to make it 10 long

• angela.orr

  Newbie

  Points: 9

  More actions

  November 26, 2008 at 3:15 am

  #215881

  How do I write a function that takes in a string and pads it with '-' (from the right) to make it 10 characters long????

• Vic.K

  SSC Eights!

  Points: 970

  More actions

  November 26, 2008 at 3:28 am

  #903607

  Left(Coalesce(@String, '') + '----------', 10)