Re: SQL substring

... WHERE field1 LIKE '%' || field2 || '%'<br /> or<br /> ... WHERE position(field2 in field1)>0<br /><br /> On
Wed,2003-11-12 at 11:07, Guy Korland wrote: <blockquote type="CITE"><pre><font color="#737373"><i>Hi, 
How can I compare two fields if one is a substring of the other?
Something like: ... WHERE StringA like '%' + StringB + '%';

Thanks,
Guy Korland


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
</i></font></pre></blockquote>