What data base are you using? In MS SQL you can use LEFT like so: where left(booktitle, 1) = 'A'
This might be the same in the other Databases, not sure. > -----Original Message----- > From: Orlini, Robert [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 10, 2006 8:50 AM > > I have a menu list of books and would like to have it list > each title alphabetically BUT only display the listing for one letter. > > For instance, the menu page would have A-Z listed and when a > user clicks on A all the titles with A would list. I realize > I have to add a where to the statement, but how do I isolate > the first letter of the book title? > > Here is my query: > > <cfquery name="Getbook" datasource="printprices"> > SELECT * FROM bookinfo > order by booktitle > </cfquery> "EMF <idahopower.com>" made the following annotations. ------------------------------------------------------------------------------ This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. ============================================================================== ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4