RE: How to suppress special characters in query

Maybe the 'no rows selected' is due to the fact that you were looking for 'A & B' in the first example, and 'A & b' in the second example?

On Mon, 2007-02-05 at 16:23 -0500, Harvinder Singh wrote:

> It works as an set option but not in the query and I was looking for
> something to work in the query without the set option:
>
> SQL> set ESCAPE '\'
>
> SQL> select * from t_account_mapper
>
> 2 where nm_login like 'A \& b%';

On Mon, 2007-02-05 at 16:02 -0500, Harvinder Singh wrote:

> Select * from tab1 where col1 like = 'A & B'
>

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

--
http://www.freelists.org/webpage/oracle-l