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?