... WHERE field1 LIKE '%' || field2 || '%'
or
... WHERE position(field2 in field1)>0
On Wed, 2003-11-12 at 11:07, Guy Korland wrote:
> 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
>