SQL substring

From: "Guy Korland" <korland(at)cs(dot)Technion(dot)AC(dot)IL>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: SQL substring
Date: 2003-11-12 14:07:04
Message-ID: 00ea01c3a926$4049b6d0$4a264484@cs.technion.ac.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
How can I compare two fields if one is a substring of the other?
Something like:
... WHERE StringA like '%' + StringB + '%';

Thanks,
Guy Korland

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Franco Bruno Borghesi 2003-11-12 14:38:31 Re: SQL substring
Previous Message Guy Korland 2003-11-12 13:44:25 SQL substring