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 > fieldinto 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). I have also written 4GL code to produce CORRECT names assuming English rules. Malcolm Weallans