query only ones starts with character

[Guest]

Hi,
I have "invoice Numer" field and some records contains just number and some
begins with a letter. How would I query up invoices that contains
letter(alpha)?
not using like [a-z]*. I don't want it to input a criteria, i want to run
it automatically.

Thank you!

 

[Ken Snell [MVP]]

You have the answer in your post:

SELECT *
FROM Tablename
WHERE Fieldname Like [a-z]*;

 

[Ken Snell [MVP]]

Typo in my first reply:

SELECT *
FROM Tablename
WHERE Fieldname Like "[a-z]*";