Insert zero before number of type text

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

Hi:
Is there any way by which i insert 0 before the value by query or any
other way. 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.
 
As per my reply to you in Yahoo Access groups

You can use an update query with SQL like:
UPDATE tblWith10000Records
SET Tech_ID = "0" & Tech_ID
WHERE Tech_ID NOT LIKE "0*";
 
Back
Top