update query for changing first letter of data in Access

[khong]

Hello everyone

I have this problem. I have a field called ID number which contains apha numeric data (one letter followed by 3 numbers e.g."A123" "A234" "B456" "C234" etc.) I now have to change all those data starting with "D" to start with "E" instead. The numeric component should remain unchanged. Can anyone tell me how to create the query (in Microsoft Access 2000) to do this?

Thank you everyone.

Khong

 

[tlbroadbent]

Update MyTable Set ID="E" & Right(ID,3)
Where Left(ID,1)="D" Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[khong]

Thank You very much