Cool way to add a leading zero to a single digit integer

As long as n is strictly less than 100:

RIGHT(100+n,2)

(Yes, now it seems obvious..  🙂
Kudos to Steve Kass

 

You must be logged in to post a comment