Easier way to 'strip' on multiple matches?

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Easier way to 'strip' on multiple matches?
Date: 2005-01-09 18:32:15
Message-ID: 20050109143121.G6902@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


I need to strip out all spaces, and all \' from a string ... is there an
easier way then doing:

select lower(replace(replace(name, ' ', ''), '\\\'', '')) from business;

Thanks ...

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Ossareh 2005-01-10 10:00:00 SQL Query Performance tips
Previous Message Dmitri Bichko 2005-01-09 11:45:54 Question about insert/update RULEs.