Update Query

[blue_echo]

I have an access table (PIN Numbers) with a text field (PIN) which has numeric values. I want all the values to be a minimum of 6 digits. I need to add zeroes in front of all single, two, three, four, and five digit values to make them all 6 digits. Does anyone know the criteria I would give to an Update query?

[pbaldy]

In SQL:

WHERE Len(FieldName) < 6