Re: Lenght of a value

Originally posted by Kderaedt
> - 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.
>

Use the LENGTH function

Originally posted by Kderaedt
> - 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?
> select WSP_SESSION_TBL.CLIENT_ID,'#',WSP_SESSION_TBL.HEADERS,'# from
> WSP_SESSION_TBL;
>

Concatenate the columns like col1||'#'||col2||'#'

--
Posted via http://dbforums.com