Gonzalo Casas wrote: > > 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..)??
It is not possible so far. With version 7.4.4 (please, do not ask for release date !) you will have the chance to do so. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
