Ok, I'm playing around (9.1.2.10317). I needed to change from an EQUAL to an IN. I have a TEXT column with comma seperated dates i.e. 2/21/2011,2/22/2011,2/23/2011.
SET VAR vmonthlydate DATE = 2/21/2011 EDIT ALL FROM schedule WHERE (CTXT(.vmonthlydate)) IN alldates gives the expected -ERROR- Parentheses required around the list of items for the IN clause. (2304) However, EDIT ALL FROM schedule WHERE (CTXT(.vmonthlydate)) IN (alldates) gives me <WARNING> No rows exist or satisfy the specified clause. (2059) What am I missing? Jan
