Re: LIKE quandary

from: Tim Fathers <tim@xxxxxxxxxxxxx>
subject: Re: LIKE quandary

Ah yes, escape doesn't really help here, but maybe you don't need a LIKE
at all, would this work?

declare global temporary table TABLE_1 as (
select * from(values('0110 EXFN 01 ABCD')) x(COL1)
) with data with replace
;;

declare global temporary table TABLE_2 as (
select * from(values('0110 EXFN 01'), ('____ EXFN 01')) x(COL1)
) with data with replace
;;

select *

from TABLE_1 T1

join TABLE_2 T2
on T2.COL1 = left(T1.COL1, length(T2.COL1))

Tim.