removing a portion of text

From: pere roca <peroc79(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: removing a portion of text
Date: 2008-10-20 11:21:31
Message-ID: 20067248.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,
I have a column with full of data like ATB-OO NCK-TT .... how can I
easily remove the "-" ? it seems that the "-" is allways the fourth letter.

thanks,
Pere
--
View this message in context: http://www.nabble.com/removing-a-portion-of-text-tp20067248p20067248.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2008-10-20 11:32:59 Re: Fwd: Copying Blobs between two tables using Insert stmt
Previous Message Harald Armin Massa 2008-10-20 11:15:46 Re: Session variables (how do I pass session data to a function)