select name
from table1
where field like 'AAA_#989';
When used with LIKE, the underscore is a wildcard which will match any
single character.
-----Original Message-----
Sent: Tuesday, February 13, 2001 11:26 AM
To: ORACLE-L
Cc: eca
I have a problem where in a statment of sql the DB Oracle doesn´t get
the line in the follow situation :
select name
from table1
where field = 'AAA #989';
I think that between A and # exist some strange character that i can´t
identify it ..
How can I do it ?
Regards
Eriovaldo
