On 07/27/2012 04:58 PM, Edson Richter wrote:
> I've a select with the following expression:
>
> select trim(both ' ' from substring(rslinha2 from 5 for position('(-)'
> in rslinha2)-6))
> from ...
>
> problem is that the spaces are not being removed from either side. What
> would be wrong?
FYI the '' is redundant, empty spaces are removed by default.
Some examples of what is in rslinha2 before the above and what you are
seeing after would help.
>
> Thanks for your help,
> --
>
> *Edson Carlos Ericksson Richter*
> /SimKorp Informática Ltda/
> Fone: (51) 3366-7964
> Celular: (51)9318-9766/(51) 8585-0796
> Embedded Image
>
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com