Re: Ordering data regardless of case

Scott Ford <sford@wvus.org> writes: >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 quick and dirty is to add a field to your table, copy requisite field into it, then use 4GL to up-shift or downshift the new field. Alternately, 4GL can clean up your data in the original field (we have written some code that does quite decent "correct English" upper/lower casing from ugly mixed case originals - without much work).