Using 1.0.2004.1 assemblys....
I need to create an 'IN' predicate using the FieldCOmpareRangePredicate() where the target of the elements of the IN list are a substring of the contents of the DB field, ie:
select * from trans_requests where substring(transcript_id,1,2) in ('TH','CN','BR') and date_received between '20050401' and '20050425'
order by transcript_year,transcript_id;
where the 'IN' list is the variable.
I do not see where this can be done. Is it possible?