Results 1 to 7 of 7
Thread: sql syntax problem
Jan 26, 2002, 20:54 #1
- Join Date
- Dec 2000
- 0 Post(s)
- 0 Thread(s)
sql syntax problem
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?