title: Pad numbers with leading zeros in an Access query
body: <p>I have a column of numbers between 0 - 6 digits long.  For those less than 6 I need to pad out with zeros to ensure they are all 6 digits i.e 12563 = 012563 or 23 000023 etc etc.  Can someone recommend a solution?</p>