Re: Check if column is substring of another column

Keaton Adams wrote:
> PostgreSQL 8.1 question:
>
> I have two columns.
> policyNumber contains a 12-13 varchar string
> AllPolicyNumbersIncluded contains one or more 12-13 varchar strings (policy nums) separated by commas

Rodrigo has given a direct answer, but you might want to consider either
an array of text for AllPolicyNumbersIncluded or better still a join to
another table. That will make your queries more natural.

--
  Richard Huxton
  Archonet Ltd