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)
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/