Criteria to filter anything that doesn't start with a number

Michael Noze
Michael Noze used Ask the Experts™
on
Hi Experts,

In Access, is there a criteria that filters anything that doesn't start with a number?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
Not sure exactly what you are looking for but using SQL try:
select col1, IsNumeric (left(col1,1)) 
from yourtable;

Open in new window

Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
You could try with:

Select * From YourTable Where Val([YourField]) = 0

Open in new window

Scott PletcherSenior DBA
Most Valuable Expert 2018
Top Expert 2014

Commented:
WHERE column_name LIKE '[!0123456789]%'

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial