update query looking for a dash

[ggreg]

I have a string of letters and numbers and I need to edit the string down

example of data
E-12345-A
EE-12333-c
T-34999
TT-22333


I need to have it search for a first dash and keep everything to the right of the first dash


I need to get rid of the E-, EE-, T-, and TT- and so on
so how do I tell it to look a first dash and keep everything to the right of the first dash?

 

[FoFa]

One way, in a query:
NewValue: mid([MyCol],instr(1,[MyCol],"-")+1)

 

[ggreg]

FoFA......
My field name is contract and in my test case my table name is Table2.....

it is giving me a compile error

mid([Table2]![contract],instr(1,[Table2]![contract],"-")+1)

I am place the above in the update of the update query

what am I doing wrong