add 0 value on select
Posted on 2010-11-22
i have a column that has quantity's in it but if my quantity is a one digit then add 0 in front this works
5 below makes it 05 or 8 makes it 08 and it leaves it if it is 55 or 88.
But the problem if there is a 3 digit quantity and the quantity for example is 323 it will only display 23, I do not want to increase the 0 because I do not want it to turn out 055 or 023.
I just need if one digit add 0 in front else more than one digit then do not add 0's