ASP Select Statement Question

[kevinj]

I have a table called EXHIBITORS and have created a login page that needs to display all exhibitors whose name begins with the letters A-K. I'm not sure how to write the ASP Select Statement.

Set RS=DB.execute("SELECT * FROM EXHIBITORS WHERE ______________ ORDER BY exhibitor_name ASC")

Any help would be greatly appreciated.

[jpjones]

Try,

Set RS=DB.execute("SELECT * FROM EXHIBITORS WHERE (exhibitor_name < "k%") ORDER BY exhibitor_name ASC")

Where the % is your DB engines' wildcard.

HTH,
JP

[aspdaddy]

Havent we done this one already :)
[webmasterworld.com...]

[kevinj]

You have a better memory than me ASPDaddy. Sorry about that. Too much time staring at the screen has made my memory suffer.