Display a string part containing delimiters

[Buckaroo8]

Hi All,
I have location names in a format with consistent delimiters, but varied names sizes.
Example:

ABC-111-DEF-1
ABC-22-DEF-2

The point is how to eliminate everything on the left of the the 1st (or leftmost) hyphen '-', including the hyphen itself, despite the varied lengths.

i.e.
ABC-111-DEF-1 > 111-DEF-1
ABC-22-DEF-2 > 22-DEF-2

Al help is welcome and greatly appreciated!!!

 

[vidru]

Here's the first thing that comes to mind:

Mid({Table.Field}, Instr({Table.Field},"-") + 1)

-dave