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.

SQL Query

SELECT
*
FROM
person
WHERE
 (salutation LIKE '%To%')
ORDER BY
person.lastname


Results

Ahsteit
Bloggs
Cap
Carrey
Diver
Duckula
Goldsworthy
Gruff
Harmony
Hassleberry-flop-flop
Heyheagle
Jahoosal
Straindove
Yorrick
of Finchery


---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Reply via email to