SELECT "W" & Mid([ITEMNO],2,24) AS ERPCODE
This code work perfectly well to change all the first character from DB to W. The problem is, I have one more data that I don't want to change the first character.
Tried stackoverflow's solution but can't get it work (Cannot give link due to new comer)...