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
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
]
-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
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
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
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
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
,
David M To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
david.m.nguycc:
[EMAIL PROTECTED] Subject: LIKE
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 (
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
10 matches
Mail list logo