Hi, I'd like to know, if it's possible to use an "ORDER BY"-sorting case-insensitive with sap-db.
For example: table COMPANYNAMES: ENTRY | COMPANY 1 | IBM 2 | bea "SELECT COMPANY FROM COMPANYNAMES ORDER BY COMPANY" does sort, but you first get all company names beginning with a upper case, then the ones beginning with a lower case. "SELECT COMPANY FROM COMPANYNAMES ORDER BY UPPER(COMPANY)" does work, but not so fast. Thank you, Ralf _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
