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

[colleen1980]

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.

[salad]

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

[John Welch]

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.