Question on how to mask characters in SQL ???

From: Michael Maretzke <michael_at_ibs.debis.de>
Date: Wed, 12 Aug 1998 10:51:22 +0200
Message-ID: <35D1578A.99E40715@ibs.debis.de>

Hello there !

I'm using a Oracle RDBMS and have a little problem. I know that some Characters are reserved characters in SQL. Inserting them into a CHAR-attribute in a table is no problem because they're masked by the single quoting marks ('). After inserting them ... how to select them from the table ?
Using "SELECT * FROM table WHERE zzz = 'Test%Test';" works realy fine. But
how can I select these lines using the LIKE condition ?

"SELECT * FROM table WHERE zzz like '%%%';" doesn't work. I wanted to select all rows containing a % in attribute ZZZ ...

Any suggestions ?

Any tips on where to get these informations in Oracle docu ;)) ???

CU Michael. Received on Wed Aug 12 1998 - 03:51:22 CDT