Received: from host1.internetdevelopment.co.uk (host1.internetdevelopment.co.uk [195.182.175.8]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f39H80894894 for ; Mon, 9 Apr 2001 13:08:00 -0400 (EDT) (envelope-from tim@celestialdesign.co.uk) Received: from timcomputer (m260-mp1-cvx1a.lin.ntl.com [213.104.193.4]) by host1.internetdevelopment.co.uk (8.9.3/8.8.7) with SMTP id RAA26838 for ; Mon, 9 Apr 2001 17:59:59 +0100 Reply-To: From: "Tim Johnson" To: Subject: Re: select substr??? Date: Mon, 9 Apr 2001 18:05:55 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Importance: Normal X-Archive-Number: 200104/124 X-Sequence-Number: 2471 Hi, I have postgres 6.x (where x is something). I have the following list of data data -------- ABC* ABC ABC- ABC+ ABC QWE~ ASD+ ASD# KLASDHK- KLASDHK+ KLASDHK KLASDHK* what I want to do is 'select distinct(data) [ignoring non alphanumeric characters] order by data' is there a way to do that? Changing the data stored in the table is not an option as the suffixes are needed elsewhere.. Please help !! Thanks, Tim.