How to pull all Characters in a string after the 1st instance of a Dash

[nagiese]

Hello, I know this is simple, but I just can't seem to remember this function. I need an Access function(s) to pull all the characters after the 1st instance of a dash in a string, where the string set before and after the 1st instance of the dash are variable. Ex. string = A104BT-RG-XL, I need -RG-XL or string = A104BTI-RG-XXL, I need -RG-XXL. Please help my old brain remember how to do this simple task.

Thanks so much

[RuralGuy]

Look at the Mid() function.

[John_G]

You would use Instr() and Mid().

Instr() to find the dash, and Mid() to extract the characters:

MyString = mid(mystring, instr(MyString,"-"))

You will get an error if your string does not contain a dash, so you might want to take that into account.