Re: justifying

Min How about this SQL, which makes no sense to do really :-), but illustrates a technique that could be used to get the kind of result you desire? select trim(tabname) || trim(rowsize || " ") from systables where tabname = "systables" output: systables104 HTH Sujit Min Kim <mkim@icpma.com> on 05/26/99 09:57:38 AM Please respond to Min Kim <mkim@icpma.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: justifying This is a multi-part message in MIME format. --------------A9CC5523D18AFC0D5D89A48C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit hi, does anyone know how to align an INT or SMALLINT to the left as far as possible? I want to cat a string and an int, but I get results like: ThisIsMyString 5 The space is undesirable since I'm naming indexes on the fly. Min --------------A9CC5523D18AFC0D5D89A48C Content-Type: text/x-vcard; charset=us-ascii; name="mkim.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Min Kim Content-Disposition: attachment; filename="mkim.vcf" begin:vcard n:Kim;Min x-mozilla-html:FALSE org:ICP;Information Technology adr:;;;;New York;;USA version:2.1 email;internet:mkim@icpma.com title:Consultant/Programmer - Internet Services fn:Min K. Kim end:vcard --------------A9CC5523D18AFC0D5D89A48C--