RE: Underscore "_" character problem

How about...............

        where product_code like '&_';

See if that works.

Thanks,
Christine Turner
DBA
IPS Sendero
Scottsdale, Arizona

From: 	drichard_at_mtlindia.com[SMTP:drichard_at_mtlindia.com]
Reply To: 	ORACLE-L_at_fatcity.com
Sent: 	Tuesday, May 30, 2000 9:24 PM
To: 	Multiple recipients of list ORACLE-L
Subject: 	Underscore "_" character problem

Dear Experts

I have found a problem in my query.

In the Product master, we have products like '728_', '728+', 'IMB7+', 'IMB7_' when we retrieve all the records using 'product_code like 'IMB7_',

     it retrieves the records belonging to 'IMB7_' alone.

But when we retrieve all the records using 'product_code like '728_',

     it retrieves the records belonging to '728_' and '728+'.  It is not recognising the "_" character when included with numbers.

any solution please.........

thanks

Richard

-- 
Author: 
  INET: drichard_at_mtlindia.com

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_at_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).