RE: strsql how to cram fields together

Thanks!

Why doesn't LEFT(fieldname,10) shorten the field for display?

When I code CHARACTER_LENGTH(LEFT(fieldname,10)) it returns the shorter length of 10 instead of the orig field length of 100.



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
Sent: Friday, March 28, 2014 3:32 PM
To: Midrange Systems Technical Discussion
Subject: RE: strsql how to cram fields together

Cast the field(s) to whatever length:
SELECT CAST (SOMELOC AS CHAR(2)) AS LOC2
FROM ALIB/AFILE

Sorry, don't have time for better example

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
Sent: Friday, March 28, 2014 2:28 PM
To: midrange-l@xxxxxxxxxxxx
Subject: strsql how to cram fields together

select left(docid,25),left(title,30) title
from rjsimage/docs00
where title like 'Amendment F%'

should cram the docid and title field together (with a space separating)

Unfortunately when displayed, it still treats the first field as length 100 so the screen is mostly blank as shown.

Any ideas how to cram fields together with a single space or two between?

Thanks




Display Data
Data width . . . . . . : 302
Position to line . . . . . Shift to column . . . . . .
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+...10....+...11....+...12....+...13.
LEFT ( DOCID , 25 ) TITLE
AS400DOC-000000000851335 Amendment Form
AS400DOC-000000000980174 Amendment Form
AS400DOC-000000003746431 Amendment Form
AS400DOC-000000001071351 Amendment Form

______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com ______________________________________________________________________
--
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.