My language is going to be off, but here's what I've got. I've got a field I need to update the content for.

Field1 in the table includes data that looks like this:

ITEM1
ITEM1
ITEM2
ITEM2
ITEM2
ITEM2
ITEM3
ITEM3
ITEM4
...

I need to remove the "ITEM" portion and leave the numeric ending with an SQL query.