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

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 orac

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 ( G

Re: LIKE and % operator

select * from sonusrpt where UPPER(subject) like '%GENERAL%'; Rick "Nguyen,

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 displ

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

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

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 name

RE: LIKE and % operator

Think Case . Is the word actually in lower case ??? Is it upper case G and then lower case eneral ?? Best way to be sure is SQL> select * from sonusrpt where upper(subject) like '%GENERAL%'; -Original Message- Sent: Monday, March 04, 2002 2:33 PM To: Multiple recipients of lis

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] > --