Kickin' a new flavor in your ear -
Anyone know the best way (Offhand, I vote the DISTINCT).
<CFQUERY NAME="Yours" DATASOURCE="Yours">
SELECT
FROM YourTable
Where lastname MATCHES '#url.letter#*'
</CFQUERY>
Paul Sizemore
Finish Line
3308 N Mitthoeffer Rd
Indianapolis, IN 46235
W: 317-899-1022 ext 3516
-----Original Message-----
From: Joseph Thompson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 12:49 PM
To: CF-Talk
Subject: Re: Selecting All Categories that start with A..
<CFQUERY NAME="Yours" DATASOURCE="Yours">
SELECT
DISTINCT Left(FieldName,1) as Ltr
FROM YourTable
</CFQUERY>
> 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
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.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
