You can also "ORDER BY ColA COLLATE NOCASE", to ignore case.
If you have more than one column, "ORDER BY ColA COLLATE NOCASE, ColB
COLLATE NOCASE"
You have to put a COLLATE NOCASE phrase with each column you want to ignore
the case on.
If you create a column, ColA TEXT COLLATE NOCASE, then the case will be
ignored with ORDER BY.
----- Original Message -----
It seems I cannot do an ORDER BY on a REALSQLDatabase. Am I correct?
Would be an extraordinarily PITA if I'm right.
--
Thom McGrath
The ZAZ Studios
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|