Access Help

[Da[]San]

Hope you guys can help me with a query i need to write.

I'm running a query which produces a list of parts with a prefix of HP- and then a load of part numbers, what i need to do is replace the HP- with H3- any ideas?

 

[RockLobster]

Replace([PartNo],"HP-","H3-")

[PartNo] is the field.