You could create a special noiseword dictionary which would have all the "generic" search words you don't want to return. In you example I guess it would look something like this...
"University,of,The" Then I'd create a view which consisted of Id, sort_title where id was a fk back to the schools table and sort_title is just the original title with any noisewords replaced by ''. The idea needs a little fleshing out but you get the drift. </rob> -----Original Message----- From: Ewok [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 5: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) : ) ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
