Re: removing a portion of text

--- On Mon, 10/20/08, pere roca <peroc79(at)gmail(dot)com> wrote:

> From: pere roca <peroc79(at)gmail(dot)com>
> Subject: re[GENERAL] moving a portion of text
> To: pgsql-general(at)postgresql(dot)org
> Date: Monday, October 20, 2008, 11:21 AM
> 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.
>
>
with fixed length

select substring(tex1,1,3) || substring(tex1,5) from t1

with variable length

select substring(tex1,1,strpos(tex1,'-'::varchar)-1) || substring(tex1,strpos(tex1,'-'::varchar)+1) from t1

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com