Hello,

I have a table with an account number field. It has about 400,000 account numbers. The problem I have is every account number has two zeros infront of the account number. For example, 00712394. Is there away to do a update query to delete the two zeros from the front of the account numbers?

Thank you

If they're all numeric like that, you could probably use CLng(). You could also use Mid().

Thank you. The Mid() expression was exactly what I was looking for.