Hey all,

I got a database that has like 120 categories.

The client wants A-Z along the top, and when A is clicked, only those
categories that start with A will show.

SO I'm trying to use SQL in the query, with a URL variable called Letter
passed when the user clicks the letter nav bar.

I am assuming that I can use a function such as Left() in SQL? Is there
anything like that?
How would I do something like this otherwise?

-Gel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to