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 13:44:25
Message-ID: 00e501c3a923$162d4180$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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Guy Korland 2003-11-12 14:07:04 SQL substring
Previous Message Damon Chong 2003-11-12 12:04:48 Re: How to know column constraints via system catalog tables