Partial string matching between columns, tables

[Yvan Strahm]

Hello,

I have a varchar column 's1' in table t1. And a varchar column 's2'
in table t2.

Do you know how one could do something like this:

select * from t1,t2 where t1.s1 like %t2.s2

Thanks for your help