Re: sorting problem

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(at)interspire(dot)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