You can create an additional db field that would contain a search name. Display name, Search name University of Alabama, Alabama University of Florida State University, Florida State University The BlahBlah Institute, BlahBlah Institute The The University of Chicago, Chicago The University of
-----Original Message----- From: Ewok [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 4:05 PM To: CF-Talk Subject: ahhh query blahhhh... I have a template topped by the alphabet, all letters are links and they need to display the correct info from the database on the page when clicked, However the info that is being sorted will be names such as..... University of Alabama (A) Florida State University (F) The BlahBlah Institute (B) The University of Chicago (C) so basically the word I need to check the first letter of could be ANYHWERE in the name ANY and ALL ideas are appreciated.......(short of finding a new line of work) : ) ______________________________________________________________________ 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
