use ljs choose ssordnumb from #values for (ljs(PartNmbr,15) & 15 is the longest length of PartNmbr + 1
Bernie Lis Megabytes, Inc. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 8:56 AM Subject: Choose Part 2 - Text Formatting > > CHOOSE SSOrdNmb FROM #VALUES FOR ((format(Partnmbr,'%%%%%%%%%%%%%%')) & > (FORMAT(CUSTCode,'%%%%%%%')) & (Ctxt(OrderQty)) & (Ctxt(Duedate))) from > Ordentry where balncdue > 0 order by partnmbr, custcode, duedate > > However, I still get varying lengths of text depending on the number of > characters in the data set. Is there a fix for this? Data on the Partnmbr > column can vary from 4 to 14 characters, and it would be REAL nice if I could > make all of the columns align. > > Or should I just ask "Wouldn't it be nice if we could define data spacing on > choose and select statements?" > > TIA > > Damon > > Damon D. Kaufman > President > Stalder Spring Works, Inc > ISO-9002 / QS-9000 Certified > 2345 S. Yellow Springs St. > Springfield, Ohio 45506 > Voice 937-322-6120 > Fax 937-322-2126 > email: [EMAIL PROTECTED] > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
