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.
