In article <482E80323A35A54498B8B70FF2B8798003E5AC7099@azsmsx504.amr.corp.intel.com>,
"Gauthier, Dave" <dave.gauthier@intel.com> writes:
> I have a temp table containg wildcarded strings and I want to select values
> froma different table using ?like? against all those wildcarded values. Here?s
> the example...
> create temporary table match_these (val varchar(32));
> insert into match_these (val) values (?jo%?);
> insert into match_these (val) values (?%denn_?);
> insert into match_these (val) values (?alt%?);
> create table footable (name varchar(32));
> (insert a bunch of records)
> Now...
> select * from footable where name in (select val from match_these)
> ... won?t work because ?in? implies equality. I want something like...
> select * from footable where name like (select val from match_these)
Why don't you use a simple join? Something like
SELECT f.name
FROM footable f
JOIN match_these m ON f.name ~~ m.val