Re: Where clause apparently failing

this is a SWAG,

did someone change the normal way the % sign works and map it to # 
instead?  I know it don't make sense but thought i'd throw it out anyways 
on a fridat afternoon :)

joe


---------------------------------------
Phineas says, "Where's Perry?"



William Wagman <wjwagman@xxxxxxxxxxx>
 
Sent by: oracle-l-bounce@xxxxxxxxxxxxx




09/19/2008 12:30 PM
Please respond to wjwagman@xxxxxxxxxxx

From
William Wagman <wjwagman@xxxxxxxxxxx>
To
"oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
cc

Subject
Where clause apparently failing






Greetings,

I'm running 64-bit Oracle 10.2.0.4.0 EE on Windows server 2003.

The select statement

select patient_id, study_number
from ucdv_cc_summaryae
where study_number = 'UCDCC#128';

returns 8693 rows. Many of these rows have study_number other than 
ucdcc#128 including ucdcc#157, ucdcc#159, ucdcc#165, ucdcc#171, etc.

ucdv_cc_summaryae is a view and the column study_number is varchar2(100). 
I am perplexed and would appreciate any thoughts. I am still having 
difficulty getting to Oracle docs online.

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
--
http://www.freelists.org/webpage/oracle-l

Other related posts: