> Scholz, Sven wrote > > > > 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? > > 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
Maybe what im asking is stupid, but.... Is it posible to create an index already lowered (or upp..)?? Gonzalo Casas _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
