By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,950 Members | 1,032 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,950 IT Pros & Developers. It's quick & easy.

Remove Leading Zeroes

P: n/a
How do you remove leading zeroes in a column?

Update 0000123456 to 123456

May 11 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 11 May 2007 09:12:49 -0700, to*******@msn.com wrote:
How do you remove leading zeroes in a column?

Update 0000123456 to 123456
using an Update query?
Update YourTable.Set YourTable.FieldName = Val([FieldName])
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
May 11 '07 #2

P: n/a
Also you could try and change the field type from 'text' to numbers
(i.e. 'integer'); if the field type is a number it won't hold leading
zeroes unless you set specific rules in the 'input mask' property for
that field

May 11 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.