Hi, That worked.
Thanks Ted -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Tuesday, June 07, 2005 9:48 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: In clause of where statement > SELECT SUM(quantity) INTO vtotal FROM table WHERE year IN (.vyears) Actually, R:Base will excuse you from the requirement for single quotes in an IN clause. It still won't work with a dotted variable, because R:Base is (correctly) considering that to be a single value and trying to match the entire string against the YEAR column. What you really want to do is: SELECT SUM(quantity) INTO vtotal FROM table WHERE year IN (&vyears) which would substitute the string directly into the SQL statement. Unfortunately, this syntax has always confused the R:Base expression parser and will generate an error. The following, however, should work: SET VAR vYears = '(' + .vYears + ')' SELECT SUM(quantity) INTO vtotal FROM table WHERE year IN &vYears By including the parens in the variable itself you are able to reduce the ambiguity and allow R:Base to process the expression. -- Larry
