Stripping characters from a field using Update Query 1

[JamesBBB]

Hi all.

I have a table with a series of characters in a particular field, i.e.:

C0012121
C0003223
AS234234
HN123123

There are about 1000 of these records and what I need to do is strip the first two characters from the front of each field and store in a new field in a table.

012121
003223
234234
123123

I have been trying to do this with an update query but am unsure of the syntax for the update, I have tried various connotations, but am getting nowhere.

Any help would be very gratefully received.

JamesBB

 

[PHV]

UPDATE yourTable SET [new field] = Mid([particular field], 3)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JamesBBB]

Thanks PHV

Worked an absolute treat

Many thanks

James