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

Brad Marks BradM at blackforestltd.com
Wed May 16 14:44:37 CDT 2012


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



More information about the AccessD mailing list