Re: Ordering data regardless of case

hi >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? Use a hash algorith to turn the names in to one or two integers depending on the length of text then sort on that. NB can also be used for very fast query on client keynames. Graham Twaddle Technical Director Beta Computers (Europe) Ltd beta@cix.compulink.co.uk A friend in need is usually on the net !