Pulling alpha hits only...

  • Thread starter Thread starter Alex F. Buiel II
  • Start date Start date
A

Alex F. Buiel II

Is there a way to construct a query so it will only pull items that start
with a letter in a particular field that contains either alphanumeric or
plain numeric information?

Thanks,
 
Alex F. Buiel II said:
Is there a way to construct a query so it will only pull items that start
with a letter in a particular field that contains either alphanumeric or
plain numeric information?
Click to expand...

Yes, using the less-obvious feature of the LIKE query operator: use a search
criterion of

LIKE [A-Z]*

to accept only alphabetic characters in the first position (with anything
thereafter).

John W. Vinson/MVP
 
Back
Top