Lenght of a value
From: kderaedt <kderaedt_at_hotmail.com>
Date: Fri, 4 Apr 2003 10:06:43 +0200
Message-ID: <3e8d3d13$0$3561$ba620e4c_at_reader1.news.skynet.be>
Date: Fri, 4 Apr 2003 10:06:43 +0200
Message-ID: <3e8d3d13$0$3561$ba620e4c_at_reader1.news.skynet.be>
Hi,
I have two question.
Karel Deraedt
Received on Fri Apr 04 2003 - 10:06:43 CEST
- 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.
- 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;
Thanks