Scholz, Sven wrote > > HI! > > When searching stuff in the database, i encountered the > problem, that strings are always compared case-sensitive. > Is it possible to tell the database to do case-insensitive > string comparisons, and if it is, how would that be accomplished?
As answered several times (and stored in the archive): you have to use function UPPER or LOWER for the column to be compared. This will have the side-effect that an index for that column will NOT be used for easier accessing the rows needed. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
