SQL sorting on number and date fields
This works for text fields:
ORDER BY LOWER ( Field ) DESC
""; ""; "" )
but not for number and date fields. Is there some SQL magic that can account for those types of fields, or do I need to create a calculation field that stores these values as text?