×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
SELECT character_length(trim(invoices)) FROM law8extn/checkout
Regards,
Guy
"Norbut, Jim"
<Jim.Norbut@Grubb-El To: <midrange-l@xxxxxxxxxxxx>
lis.com> cc:
Sent by: Subject: SQL question du jour
midrange-l-bounces@m
idrange.com
01/07/2008 11:45 AM
Please respond to
Midrange Systems
Technical Discussion
Have a field that is 512 characters long.
How do I find out how many characters are actually used thought.
CREATE TABLE LAW8EXTN/CHECKOUT)
TRANS_NBR CHAR(10) NOT NULL WITH DEFAULT,
CHECK_DATE DATE NOT NULL WITH DEFAULT,
VENDOR CHAR(9) NOT NULL WITH DEFAULT,
VENDOR_VNAME CHAR(50) NOT NULL WITH DEFAULT,
BASE_CHK_AMT NUMERIC(15,2) NOT NULL WITH DEFAULT,
INVOICES CHAR (512) NOT NULL WITH DEFAULT);
SELECT character_length(invoices) FROM law8extn/checkout
Gives me
CHARACTER_LENGTH
512
512
512
512
512
512
512
And so on and so on.....but I know for a fact that not all 512
characters are used.
SELECT invoices FROM law8extn/checkout
INVOICES
200512:200512
3631
ADV302007
77751
5335250:F0008520
110405:113005
47285:44512
3351:3352:3353:3354:3355
14564743:14505256
311335:311060
140
2005120105
932444
6001607910
519979
121605
121605
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/midrange-l.
midrange.com
