[EMAIL PROTECTED] schrieb: > On Fri, 27 Apr 2007 at 18:11, Diez B. Roggisch wrote: >> I wouldn't call the sorting order unusual - first sort after last name, >> then first name. but exactly that can be accomplished by using an order >> by clause that features several columns. The concatenation is >> unnecessary. But obviously that information wasn't too welcome... > > Amy Smith > Frank Smithson > Roy Smither > > Sorted normally (like your order by): > > Smith, Zane > Smither, Roy > Smithson, Amy > > Sorted by concatenation (ignoring case): > > SmithsonAmy > SmitherRoy > SmithZane > > If you ask me, that's a weird sorting order :)
Darn, I didn't think about that :) Sorry, it sure _is_ a weird sorting order ;) Diez --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
