In your query use:
WHERE Name Like 'A%'
The percent sign is the wildcard in SQL.
C. Hatton Humphrey
> -----Original Message-----
> From: Angel Stewart [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 12:37 PM
> To: CF-Talk
> Subject: Selecting All Categories that start with A..
>
>
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
