Where clause apparently failing
Date: Fri, 19 Sep 2008 09:30:22 -0700
I'm running 64-bit Oracle 10.2.0.4.0 EE on Windows server 2003.
The select statement
select patient_id, study_number
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.
Univ. of California at Davis
IET Campus Data Center