Change grouping

[cstuckey]

Can you help me.

I have about 2000 records with Part Number XXXCOGxxxxx. This Should be C0G. Ex:

SPN
RPE122COG101K
RPE122COG681K
RPE122COG101K
RPE122COG681K
GRM40COG100J
GRM40COG100K
GRM40COG101J
GRM40COG150J
GRM40COG220J
GRM40COG221J
GRM40COG271J
GRM40COG470J
GRM40COG471J
GRM42-6 COG100J
GRM42-6COG220J
GRM42-6COG472J

What to write a query to change just the COG portion. Can you tell me the formula?

Thanks
Chris

 

[KenHigg]

If you never expect to see the O then you may be able to use the replace() function...