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

Insert zero before number(as a first character) of type text

P: n/a
Hi:
Is there any way by which i insert 0 before the value by query. I have
a table contains 10,000 records and because of some reason i need to
move 0 before number of field Tech_ID. Type of field is Text.

Thank You.

Sep 2 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
co*********@gmail.com wrote:
Hi:
Is there any way by which i insert 0 before the value by query. I have
a table contains 10,000 records and because of some reason i need to
move 0 before number of field Tech_ID. Type of field is Text.

Thank You.
In the querybuilder enter something like
NewTechID : "0" & TechID
Sep 2 '06 #2

P: n/a
Do you want to permmanently change the field values? If so you can build an
update query in the query builder (go to query menu and choose update
query). Choose the field Tech_ID and set the "update to" field to be: "0" &
[Tech_ID].
If you don't want the changes to be permanent, you could just make a select
query with a field called something like "modifiedTech_ID" and define it as
"0" & [Tech_ID]. Then you could use this query in place of the table.
-John
<co*********@gmail.comwrote in message
news:11*********************@m73g2000cwd.googlegro ups.com...
Hi:
Is there any way by which i insert 0 before the value by query. I have
a table contains 10,000 records and because of some reason i need to
move 0 before number of field Tech_ID. Type of field is Text.

Thank You.

Sep 3 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.