Update records to 06-xxxx where they are 05-xxxx 1

[AccessGuruCarl]

Can I write an update query to change only the starting value of a field.

I have records with

05-1A
05-1B
...
...

I need to change the 05 to 06!

Thanks


AccessGuruCarl
Programmers helping programmers
you can't find a better site.

 

[AccessGuruCarl]

I forgot to mention.

Some records are like

C13
TEG13
WM13

These values remain the same.

So I where clause!

AccessGuruCarl
Programmers helping programmers
you can't find a better site.

 

[jsteph]

One option would be replace([thefield],'05-','06-')

Put the above in the 'update to' cell of [thefield] or whatever that field is named, in an update query.

Obviously, this is dependant on the data being in a similar format to what you gave, ie, if one value was "05-ceg05-6547", for example, both instnaces of 05- would be replaced.
--Jim

 

[Golom]

UPDATE myTable

SET myField = '05-' & Mid(myField,4)

Where Left(myField,3) = '06-'

 

[Golom]

Got it backwards

UPDATE myTable

SET myField = '06-' & Mid(myField,4)

Where Left(myField,3) = '05-'

 

[AccessGuruCarl]

Thanks for the posts....

jsteph - It worked fine in the update query.

Here's a star.....

AccessGuruCarl
Programmers helping programmers
you can't find a better site.