Use 'AAA_#989', the _ means any 1 character substitution.
Eriovaldo do Carmo Andrietta wrote:
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
--
Scott Canaan (srcdco@rit.edu)
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Canaan
INET: srcdco@ritvax.isc.rit.edu
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Feb 13 2001 - 12:22:37 CST
