I have some fileds in my table like this.

name examcode month
1 jan 03
23 fab 02
44 nov 03
My problem is this i want to replace month fileds with this
if jan 03 in the examcode replace the month with 1
or
if nov 03 in the examcode replace the month with 11
I have more than 2000 records in examcode. How it can be possebel.
thanks