I have a field with names in which I wish to sort using ORDER BY. The data comes back as [A-Z][a-z] Apple Blackberry Kiwi aardvark banana It should be [Aa-Zz] aardvark Apple banana Blackberry Kiwi They seem to be sorting using the ASCII equivelant. Is there any way to do a case insensitive sort?. Thanks in advance Grant
