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 -- //www.freelists.org/webpage/oracle-l