>>I know that you could probably sort a field by first assigning a collation such as the following
Really not trivial. For some languages, a collation is not enough. I may be wrong, but I think I've learned that in Spanish for instance, the double l or ch are not considered as a two letters but as a "digraph" , and treated as one character in alphabetic sort. For instance, "chacal" comes after "cucaracha" because ch is a digraph and comes after all other single "c" letters. And you also have accented letters in may languages. In French, letters like éèêë have the same value as e, if the other letters are not e, if é is compared to e for instance, the word comes after. Ex: élevé (raised) comes after élève (pupil), because è comes after e, but élévation (raising) comes before élevé, even if its third letter e comes before the third letter é in élévation, because a has predominance over é. So you see it is not simple. However, this case of collision is very rare, and only dictionaries must really care about it. In casual applications, just removing the accent will do it, but you must create a key with all accent removed and sort your list on that key, not the real name. I have a genealogical database with names in French, Spanish, German, Polish, and this is the method I use. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308879 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
