Re: ltrim & rtrim

Jeremy Ovenden wrote:
>
> Jeepers, embarassingly simple and obvious and cannot believe that I never
> came across it before!!!
>
> "Paul Quenneville" <paulq_at_home.com> wrote in message
> news:R6aL7.184729$5h5.79369278_at_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
> > >
> > >
> > >
> > >
> > >
> >
> >

Its actually new from only version 8.1.6 (maybe 8.1.5) - so no need to be embarrassed - Oracle took a long time to get it in!

Cheers
C

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."