I think this works: SET VAR vGreatFall TEXT = '(t1.Humpty + '', '' + t2.Dumpty)'
where '' is two single quotes - not a double quote. I also think it would be clearer to remove the space after the comma and use the & concatenator instead: ...'','' & t2... Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker Sent: March-01-16 10:33 AM To: Stephen Markson Subject: [RBASE-L] - RE: Should've quit at dinner time Bruce I would do it like this SET VAR vq = (CVAL(‘QUOTES’)) SET VAR vGreatFall TEXT = ('(' + .vq + 't1.Humpty' + .vq + ',' + .vq + 't2.Dumpty' + .vq + ')' ) Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Bruce Chitiea Sent: Tuesday, March 1, 2016 2:34 AM To: [email protected] Subject: [RBASE-L] - Should've quit at dinner time All: I need to deliver this string into an ampersand variable: (t1.Humpty + ', ' + t2.Dumpty) ... ala: SET VAR vGreatFall TEXT = (t1.Humpty + ', ' + t2.Dumpty) ... and for the life of me I can't remember how to frame it up with quotes and parens. ?? Thanks Bruce Chitiea SafeSectors, Inc. 909.238.9012 mobile
