Hi, I've got a question concerning the escaping of special characters within LIKE clauses. I understand that it's possible to specify the escape character by using ESCAPE - and for the single quotes you can use '' to escape it.
My problem is that the round brackets () are also special characters (used for patterns such as 'Pre(r-u)(r-u)on *'). When querying a like pattern with a not closed round bracket such as 'SAP (Germany' the kernel will throw "Invalid pattern" exception. Hence, if you don't care about escaping the brackets in your app it might lead to problems. As well, the queries might return a resultset which is probably not what you want, if you search for 'SAP (Germany)' without escaping, the brackets will not be treated as usual chars.. This is probably the reason for Mohameds problem referred in: http://listserv.sap.com/pipermail/sapdb.general/2002-November/015213.html Is there any way around such as config parameters to disable this or a standard escape character? The documentation doesn't state the brackets as special chars - I think it would help to include it there. Regards, Matthias -- Matthias Bild Inxnet GmbH _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
