Something like:
select * from towns where upper(left(name,1))='#Letter#'
In the above, the table is "towns" and the field that holds the town name is "town".
"Letter" was the form parameter (which must be
upper case for the above to work).
HTH,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server
Join the DevCon community at www.coolfusion.com/devcon
----- Original Message -----
From: "W Luke" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, August 25, 2001 12:59 PM
Subject: Quick query question (qqq)
> I have a list of towns (3000 or so), and need to output them per letter in
> the alphabet. For instance, I might need to pull up all towns starting with
> the letter M. To choose the letter, there will be a drop down box with A-Z
> in it (form.letter)
>
> How can I do this in my query?
>
> Cheers
>
> Will
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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