Re: Selecting All Categories that start with A..

[Joseph Thompson]

<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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists