Pad a number with leading zeros in SQL to make uniform char length
October 01, 2018 · 1 min readWhen you are in need of transforming a number to have some character to be prefixed in order to make the chars in the number a specific number long, here is one way to do it.