RE: LIKE and % operator

2002-03-05 Thread Michael Cupp
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

LIKE and % operator

2002-03-04 Thread Nguyen, David M
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

RE: LIKE and % operator

2002-03-04 Thread Guidry, Chris
] -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

RE: LIKE and % operator

2002-03-04 Thread Shaw John-P55297
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

RE: LIKE and % operator

2002-03-04 Thread Whittle Jerome Contr NCI
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

Re: LIKE and % operator

2002-03-04 Thread Viktor
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

Re: LIKE and % operator

2002-03-04 Thread Suzy Vordos
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

Re: LIKE and % operator

2002-03-04 Thread Rick_Cale
, David M To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] david.m.nguycc: [EMAIL PROTECTED] Subject: LIKE

RE: LIKE and % operator

2002-03-04 Thread Bellows, Bambi
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 (

RE: LIKE and % operator

2002-03-04 Thread Pardee, Roy E
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