Steve, You can left & right justify the two columns:
choose vcustcont from #values for + ( (LJS(CC_contact, n)) & (RJS(CC_OfficeExt, n)) & (LJS(CC_Mobile1, n)) & (RJS(CC_HomePhone, n)) ) + from CustContacts where custnub2 = .This_Custnub2 ORDER BY CC_contact TITLE 'my Heading' where "n" is the number of characters in your column. I'm not sure about a heading v6.5 but I think the TITLE option was available by then. Regards, Alastair. PS: check my brackets are matched!! ----- Original Message ----- From: Steve Breen To: RBASE-L Mailing List Sent: Tuesday, November 04, 2008 11:32 AM Subject: [RBASE-L] - Re: One works - other will not Alastair, Thanks This works great but is there any way to space it out and get a heading. I have to use 6.5++ for now. R>choose vcustcont from #values for (CC_contact & CC_OfficeExt & CC_Mobile1 & CC_HomePhone) from CustContacts where custnub2 = .This_Custnub2 Thanks Steve ------------------------------------------------------------------------------ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Alastair Burr Sent: Tuesday, November 04, 2008 6:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: One works - other will not Steve, Put the concatenated columns in brackets: choose vcustcont from #values for (CC_contact & CC_OfficeExt) from CustContacts where custnub2 = .This_Custnub2 Regards, Alastair. ----- Original Message ----- From: Steve Breen To: RBASE-L Mailing List Sent: Tuesday, November 04, 2008 10:29 AM Subject: [RBASE-L] - One works - other will not The 1st onr works 2nd will not. What did I do wrong ?? R>choose vcustcont from #values for CC_Id, from CustContacts where custnub2 = .This_Custnub2 R>choose vcustcont from #values for CC_contact & CC_OfficeExt from CustContacts where custnub2 = .This_Custnub2 Steve ---------------------------------------------------------------------------- No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.6/1765 - Release Date: 03/11/2008 16:59 ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.6/1765 - Release Date: 03/11/2008 16:59
