Hello.
Try this:
--
VALUES(replace('text1 text2 text3 text3 text4' , ' ' ,''
))
--

Sincerely,
Mark B.

> I am trying to remove all blank chars in middle of the string "text1
> text2 text3 text3 text4"
>
> with following stmt:
>
> VALUES(translate('text1 text2 text3 text3 text4' , ''
> ,' ' ))
>