Batch update with matching in SQL

[Etruscan]

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.

[phranque]

UPDATE tablename SET Field1=TRIM(LEADING 'TRIM' FROM Field1);

[Etruscan]

Awesome. Thanks so much. I completely missed the TRIM syntax.