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

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.

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

colleen1980@gmail.com wrote:In the querybuilder enter something like
NewTechID : "0" & TechID

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

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


<colleen1980@gmail.comwrote in message
news:1157238609.648471.44670@m73g2000cwd.googlegro ups.com...