I am trying to produce a quick A-Z index of items stored in my database based on the initial letter of the product.
For instance, I will have
A B C D E F .... at the top of the page and then below it a dynamic table which will show only those products beginning with A etc
Is it possible to write something like as the SQL statement
SELECT "aaa,bbb,ccc from tbl_xxx where LEFT(aaa,1) = "+Request("Initial")
I am getting invalid column name
Is there an easy SQL way to do this...