I've been making a site with a database. I want people to be able to browse the database by selecting the first letter of the word.

But I can't get it to work.

Here is my select statement:-
Set oRs = oConn.Execute (" select * from link_data where link_name like '" & letter & "%' ")

Here is the error I recieve:-
Syntax error (missing operator) in query expression 'link_name like ''p'%''

Any ideas?

Cheers,
The Cageybee

actually u'd be astonished to realise u were a bit jumpy to post ur question :)
u have inserted an extra ' in ur select statement, it should look like this 'p%' , the good news is .. ur syntax is ok, the bad news is .. ur varriable (letter) cought an extra quatation through god knows where operation, the problem with that is , u need to post ur full script for audition of how ur letter varriable was assigned