select * from targettablename where type in ('AA','BB') and stype like 'BB%' and X like 'CC%' and y='DDD';
select * from targettablename where type in ('AA','BB') and X like 'CC%' and y='DDD';
select * from targettablename where type = 'AA' and stype like 'BB%' and X like 'CC%' and y like 'DD%';