I have a bit of an issue in attempting to retrieve very specific rows from a table while using workflow.

I have a pattern that I need to extract from a sting

Variation are as follow:

ABC123421-2345D

AB12334-23

ABC-3423232-23111D

Basically, I need to exact the first set of Alpha character and the last set. The first set has 2-3 Characters and the Last set has 0-2. 

I have created a pattern match token for the first:

([a-z][a-z][a-z]|[a-z][a-z])

And the last:

([a-z][a-z]|[a-z])\z

No idea where to go from here, I need it to query SQL with something like this

like 'Firstset%lastset'

Any help is appreciated.