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
> >
> >
> >
> >
> >
>
>
Received on Thu Nov 22 2001 - 11:11:05 CST
