Aha! Thanks! Yes, it was a SQL sort, but I'll also (just because I want to have that an option for other situations - thanks to you both)
___________________ Sent from my iPad 2 8) On Sep 15, 2011, at 11:55 AM, Shannon Henderson <[email protected]> wrote: > The sort is case sensitive. To do a case insensitive sort, order by > upper(column) or lower(column). > > ------------------------ > Shannon Henderson > Web Support Services > Reed College > Portland, Oregon > 503/517-7745 > [email protected] > > On 9/15/2011 5:01 AM, Dale Graham wrote: >> Does any one on this list know why this is happening (and better yet, how to >> fix?) this >> >> Note that we're seeing this behavior using J2EE and compiled >> Witango/Terascribe class files. >> >> >> We have a list of educational degrees that are maintained in a lookup table. >> >> We get the list, and then display the degrees in a popup, sorted >> alphabetically (in theory) >> >> While the list SEEMS to work largely correctly, it always fails where there >> are mixed capitalizations. >> >> That is >> >> PBPM >> PNP >> PT >> PhD >> >> Where, obviously, PhD should have been placed after the PBPM degree, not >> after the PT degree >> >> and >> >> SB >> SJD >> SM >> SW >> ScB >> ScD >> ScM >> >> where the three Sc degrees should have been placed after the SD, not the >> SW... >> >> I do have a fix in mind, but it's complicated, and I'd love to avoid using >> it. >> >> E.g., create a new column, put the lower case of all the values in that, >> sort on that, display the correctly capitalized degrees.... >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to [email protected] >> with "unsubscribe witango-talk" in the body. >> >> > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. > ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
