Bug or Not? Taking STRING of a string whilst making leading zeros

[toml_12953]

(01-30-2018 08:17 PM)Han Wrote:  Either make a "constant" string of more-than-enough 0's and append it to the front of your number, or create a function that will produce such a string by repeatedly adding a small string of zero's to itself and then append this to the front. Then simply "cut" the desired length using MID().

Yup, that what the line I posted does. It works and is pretty easy to understand.