Angel:
As I remember there is a left().
But you don't need it.
The SQl below should do you fine (replace the stuff in []'s with
the appropriate info):
Select [FIELDS]
FROM [TABLE]
WHERE [CategoryName] LIKE '#URL.Letter#%'
I'd also suggest a clustered index on the [CategoryName] field.
HTH
Craig Fisher
Macromedia Certified Instructor
Macromedia Certified Advanced ColdFusion 5 Developer
[EMAIL PROTECTED]
801-791-8251
-----Original Message-----
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 10:37 AM
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
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