As Hilmer said:
? SUBSTR(TRANSFORM(STRTRAN(ALLTRIM(STRTRAN("1"+STR(MyNumber,12,6),"0"," "))," ","0")),2)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
