How to search ignoring spaces and minus signs

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to search ignoring spaces and minus signs
Date: 2010-10-13 17:45:11
Message-ID: 07B6CB30B3A94B2C8BC93C2C528CAA69@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

CHAR(20) columns in 8.4 database may contains spaces and - signs like

13-333-333
12 3-44
33 33 333
12345

User enters code to search without spaces and - signs, like 12344
How to search for product code ignoring spaces and - signs?

For example searching for code 12344 should return
12 3-44 as matching item.

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gergely Fábián 2010-10-13 17:48:09 error_question
Previous Message Brian Hirt 2010-10-13 17:07:33 Re: Copying data files to new hardware?