Re: removing a portion of text

--- On Mon, 10/20/08, pere roca <peroc79@gmail.com> wrote:

> From: pere roca <peroc79@gmail.com>
> Subject: re[GENERAL] moving a portion of text
> To: pgsql-general@postgresql.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