Ordering data regardless of case

Just wondering what folks do... suppose one has a database table with a list of customer names. Further suppose that the names have a mixture of upper and lower case in the first character. How does one sort it properly? The right answer of course is clean up the data and subsequently have applications enforce strict rules as to case for insert and update. We're not interested in the, "right" answer however, just the practical one, i.e. is there anyway to select data from a column and have it ordered, regardless of case? Thanks for any info. We're running 7.00.UC4 on Sequent 2000 machines, though this problem should apply to any level and any platform. Have thought about NLS, but that solution seems rather drastic for such a simple problem... -- Scott F. Ford, DBA / Unix SA | sford@wvus.org bps (Benefit Panel Services) | elroy.jpl.nasa.gov!wvus!sford 888 South Figueroa Street, Suite 1400 | Voice: (213) 489-2694 Los Angeles, CA. 90017 | FAX: (213) 489-7973 "...The bozone layer: shielding the rest of the solar system from the earth's harmful effects...."