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 :) --David --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
