<http://schema.org/articleBody>
"Try this select docid || ' ' || title from rjsimage/docs00 where title like 'Amendment F%' Thanks, Carl Novit Vice President Extension: 7708 From: &amp;quot;Stone, Joel&amp;quot; &amp;lt;Joel.Stone@xxxxxxxxxx&amp;gt; To: &amp;quot;midrange-l@xxxxxxxxxxxx&amp;quot; &amp;lt;midrange-l@xxxxxxxxxxxx&amp;gt; Date: 03/28/2014 04:27 PM Subject: strsql how to cram fields together Sent by: midrange-l-bounces@xxxxxxxxxxxx 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 sep..."^^<http://www.w3.org/2001/XMLSchema#string>
<http://archive.midrange.com/midrange-l/201403/msg00874.html>