[AccessD] How to Eliminate a Numeric String from a Field in an Access Query

We are pulling data from a purchased package via an Access 2007 Query.

One of the fields has a combination of Alphabetic characters and
numbers, such as these examples.

ABC 1234
BB  1234556
CCC 55

Is there a way to eliminate the numeric part of the strings in these
records within an Access Query?

"ABC 1234" would become ABC
"BB  1234556" would become BB
"CCCDD 55" would become CCCDD

Thanks,
Brad