Re: ltrim & rtrim

From: Paul Quenneville <paulq_at_home.com>
Date: Thu, 22 Nov 2001 16:56:17 GMT
Message-ID: <R6aL7.184729$5h5.79369278@news3.rdc2.on.home.com>

try trim

"Jeremy Ovenden" <jovenden_at_hazelweb.co.uk> wrote in message news:tvqb4uctcplf64_at_corp.supernews.com...
> Sorry if this is too simple...when I wish to remove any leading & trailing
> spaces from a string in SQL, I have been using e.g.
>
> l_str := ltrim(rtrim(l_str));
>
> This came about from me using ltrim initially to remove trailing spaces.
>
> Is there a built-in that does this more elegantly?
>
> cheers
> -- Jeremy
>
>
>
>
>
Received on Thu Nov 22 2001 - 10:56:17 CST