Select addresses that don't have street numbers

Question

I want to QA the address field in my table by removing records that don't have a street number anywhere in the cell.  Because StreetMap Premium can use a street number that is not at the beginning of the cell, I still want to keep records in which the number is after the street name, so simply sorting or using "begins with" is not an option.  I've tried selecting by using "has value(s)" and "doesn't have value(s)," but I keep getting 0 records selected.  So for example, if the cell has

Smith Ave 226

how do I come up with a way to either select that record so I can invert the selection or select records that don't have any numbers?

Thanks.

CherylCollins · Accepted Answer

Thanks for the suggestion.  I didn't get a chance to check it out because I discovered that what I was doing wrong was using "does not include the value(s)," when I should have been using "does not contain the text" because the address field has both letters and numbers.