Re: Ordering data regardless of case

Ting Barrow (tingb@delphi.com) wrote: > 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). Bottom line: garbage in, garbage out. Control your input and the output is a piece of cake. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- !!!!!! ! ! !! ! ! ! ! ! Danni Bauer ! ! ! ! !! ! !! ! ! : : : : : : : : : : : bauer@gtetel.com : : :::::: : : : : : : : . . . . . .. . .. . 73764.63@compuserve.com ...... . . . . . . .