RE: LIKE and % operator
I would try select * from sonusrpt where upper(subject) like '%GENERAL%'; Might be a case issue w/ subject - if the word is General as you state above, you are searching for general below. Good Luck -Original Message- Sent: Monday, March 04, 2002 3:33 PM To: Multiple recipients of list ORACLE-L I am running oracle8i on solaris8. I have a word ( General ) in my column named subject, I try to run SQL using LIKE and % to grep any data having the word ( General ) but it displayed no rows selected. Does someone have any idea why? Below is my SQL I used. SQL select * from sonusrpt where subject like '%general%'; no rows selected. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Cupp INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
LIKE and % operator
I am running oracle8i on solaris8. I have a word ( General ) in my column named subject, I try to run SQL using LIKE and % to grep any data having the word ( General ) but it displayed no rows selected. Does someone have any idea why? Below is my SQL I used. SQL select * from sonusrpt where subject like '%general%'; no rows selected. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: LIKE and % operator
Try, SQL select * from sonusrpt where subject like '%GENERAL%'; or SQL select * from sonusrpt where lower(subject) like '%general%'; -- Chris J. Guidry P.Eng. EE ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] -Original Message- From: Nguyen, David M [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 01:33 PM To: Multiple recipients of list ORACLE-L Subject: LIKE and % operator I am running oracle8i on solaris8. I have a word ( General ) in my column named subject, I try to run SQL using LIKE and % to grep any data having the word ( General ) but it displayed no rows selected. Does someone have any idea why? Below is my SQL I used. SQL select * from sonusrpt where subject like '%general%'; no rows selected. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guidry, Chris INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: LIKE and % operator
The search is case sensitive, try something like select * from sonusrpt where upper(subject) like '%GENERAL%'; -Original Message- Sent: Monday, March 04, 2002 2:33 PM To: Multiple recipients of list ORACLE-L I am running oracle8i on solaris8. I have a word ( General ) in my column named subject, I try to run SQL using LIKE and % to grep any data having the word ( General ) but it displayed no rows selected. Does someone have any idea why? Below is my SQL I used. SQL select * from sonusrpt where subject like '%general%'; no rows selected. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: LIKE and % operator
David, If you have General with an upper case G and are looking for general with a lower case g, you won't return any records. It's that old case sensitive thing. Try this: select * from sonusrpt where Upper(subject) like '%GENERAL%'; Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Nguyen, David M [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Subject: LIKE and % operator I am running oracle8i on solaris8. I have a word ( General ) in my column named subject, I try to run SQL using LIKE and % to grep any data having the word ( General ) but it displayed no rows selected. Does someone have any idea why? Below is my SQL I used. SQL select * from sonusrpt where subject like '%general%'; no rows selected. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whittle Jerome Contr NCI INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: LIKE and % operator
Try changing the query to say: select * from sonusrpt where lower(subject) like '%general%' / --- Nguyen, David M [EMAIL PROTECTED] wrote: I am running oracle8i on solaris8. I have a word ( General ) in my column named subject, I try to run SQL using LIKE and % to grep any data having the word ( General ) but it displayed no rows selected. Does someone have any idea why? Below is my SQL I used. SQL select * from sonusrpt where subject like '%general%'; no rows selected. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: LIKE and % operator
Case needs to be considered, eg., '%General%' or use of upper/lower functions. Nguyen, David M wrote: I am running oracle8i on solaris8. I have a word ( General ) in my column named subject, I try to run SQL using LIKE and % to grep any data having the word ( General ) but it displayed no rows selected. Does someone have any idea why? Below is my SQL I used. SQL select * from sonusrpt where subject like '%general%'; no rows selected. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: LIKE and % operator
select * from sonusrpt where UPPER(subject) like '%GENERAL%'; Rick Nguyen, David M To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] david.m.nguycc: [EMAIL PROTECTED] Subject: LIKE and % operator Sent by: root@fatcity. com 03/04/2002 03:33 PM Please respond to ORACLE-L I am running oracle8i on solaris8. I have a word ( General ) in my column named subject, I try to run SQL using LIKE and % to grep any data having the word ( General ) but it displayed no rows selected. Does someone have any idea why? Below is my SQL I used. SQL select * from sonusrpt where subject like '%general%'; no rows selected. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: LIKE and % operator
Looks like you're running into a case-sensitivity issue. Try select * from sonusrpt where upper(subject) like upper('%general%'); HTH. -Original Message- Sent: Monday, March 04, 2002 2:33 PM To: Multiple recipients of list ORACLE-L I am running oracle8i on solaris8. I have a word ( General ) in my column named subject, I try to run SQL using LIKE and % to grep any data having the word ( General ) but it displayed no rows selected. Does someone have any idea why? Below is my SQL I used. SQL select * from sonusrpt where subject like '%general%'; no rows selected. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: LIKE and % operator
Are the results any different if you say select * from sonusrpt where subject like '%GENERAL%'; ? Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Monday, March 04, 2002 12:33 PM To: Multiple recipients of list ORACLE-L I am running oracle8i on solaris8. I have a word ( General ) in my column named subject, I try to run SQL using LIKE and % to grep any data having the word ( General ) but it displayed no rows selected. Does someone have any idea why? Below is my SQL I used. SQL select * from sonusrpt where subject like '%general%'; no rows selected. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).