This is an access query.

I do not need to modify any records I just need to extract the data so that I only have the 09* Part #s in a field so that I can use that field to link to a different table.

There are about 14,000 records that I need to pull the 09* out of.

I was a little confused when attempting to use Left, Right and Mid because the 09 can be at the beginning middle or end of the data.