I want the length to be 6.
If its 5 in length I want to add a zero at the end
If the value is 4 in length I want to add a leading zero and a zero at the end.
Does some have an example of this.
Select number from table
I want the result to be: