Re: Lenght of a value

"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:08:43 CEST