Re: Lenght of a value

I will tell my boss to send me to a course.

"Guido Konsolke" <Guido.Konsolke_at_triaton.com> wrote in message news:1049450728.972947_at_news.thyssen.com...
> "kderaedt" wrote...
> > Hi,
>
> Hi Karel,
> comments embedded...
>
> >
> > I have two question.
> > - Is there a where clause available that can count the number of
 characters
> > in a field. In other words, only displays the records where the number
 of
> > characters is more than 5.
>
> Try: WHERE LENGTH(column) > 5.
> Note: Will not use any index.
>
> > - I how a script that dumps data into a file with spool. I'm using a
 marker
> > to separate the fields, on of the fields is a varchar of 2000. But most
 of
> > the time the number of characters is less than 2000. How can I put the
> > marker at the last character of this field, an not after the 2000
> > characters?
>
> Do you know about 'SELECT LTRIM(info) FROM documentation'?
>
> > select WSP_SESSION_TBL.CLIENT_ID,'#',WSP_SESSION_TBL.HEADERS,'# from
> > WSP_SESSION_TBL;
> >
> > Thanks
> >
> > Karel Deraedt
>
> Please try some learning / training before posting.
>
> Greetings,
> Guido
>
>
Received on Fri Apr 04 2003 - 12:49:12 CEST