I am having problems getting my sql syntax correct. This is what I have and it doesn't work:

SELECT id, name as AName FROM artists WHERE Mid(name, 1, 1) Not Between Asc('A') And Asc('z') ORDER BY name

There error I get is Expected End of Statement

I need to return all records where name doesn't start with a letter. This sql statement is querying an Access database via asp.

Can anyone tell me how it should be written?

Thanks!