RE: How to suppress special characters in query
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: Harvinder.Singh@xxxxxxxxxxxxx
- Date: Tue, 06 Feb 2007 22:27:27 +0100
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)
===
Other related posts:
