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: [EMAIL PROTECTED] 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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
