There are smarter/faster/bettter ways. But here is one. Create a second field, and have that be the name for selection purposes. Then sort by actual name.
When you insert into the db, put the data in two fields, RealName and NewName. If you don't want to precalc this data, or can't , you can do it live, but it will cost. I think a simple mask of words you DONT care about can solve this. Build a list of words that do not matter for the sort. <cfset IgnoreList="university,of,the,college,institute"> select em all. create a list of the name column ValueList() replace each word in the ignore list with "" (cfloop through ignore list, replacing with newNameList with "") list to array add a column to the query, populating with array (queryAddColumn query of query to get the list for "A", order by original name field It ain't quick, but it might work. >>> [EMAIL PROTECTED] 05/23/02 05:05PM >>> 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) : ) ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
