Insert zero before number of type text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anna - 02 Sep 2006 23:13 GMT

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.

Reply to this Message

Duane Hookom - 03 Sep 2006 00:13 GMT

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*";

Signature

Duane Hookom
MS Access MVP

> Hi:
> Is there any way by which i insert 0 before the value by query or any
[quoted text clipped - 3 lines]
>
> Thank You.

Reply to this Message