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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
