Would doing it this way require an index:
create index lower_lastname on table x lower(lastname);
?
Regards,
Chris Smith
Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia
Ph: +61 2 9517 2505
Fx: +61 2 9517 1915
email: info@interspire.com
web: www.interspire.com
Michael Fuhr wrote:
> On Fri, Dec 17, 2004 at 11:28:36AM +1100, Jamie Deppeler wrote:
>
>
>>Problem i am having at the moment i cant get a true alpha sort to work
>>as Order By is sorting A..Z then a..z where i need aA..zZ sort
>>independant of case.
>
>
> ORDER BY LOWER(person.lastname)
>
> or
>
> ORDER BY UPPER(person.lastname)
>
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.4 - Release Date: 12/15/2004