parse string

[deb]

Access 2010

I have a field called Description and need to parse a 12 space word that begins with A9B. i.e. A9B123456789012
It could have words before and after A9B123456789012.

like
A9B123456789012 oil mount
A9B123456789012 fire
missing A9B123456789012 washer
A9B123456789012


I need to have A9B123456789012 only in the new query field

can anyone help...

 

[baderms]

SELECT Description FROM tablename WHERE Description Like "*A9B123456789012*"

 

[deb]

I figured it out...

Part #: Mid([Description],(InStr([Description],"A9B")),11)