<< I have a TEXT column with comma seperated dates i.e. 2/21/2011,2/22/2011,2/23/2011. EDIT ALL FROM schedule WHERE (CTXT(.vmonthlydate)) IN (alldates) gives me <WARNING> No rows exist or satisfy the specified clause. (2059) >>
IN will not convert the single text value in the AllDates column into a comma-separate list, it will treat it as a single long text value. If you need to maintain this structure for your table (which, as I'm sure you know, violates basic normal form for relational databases), you have to use CONTAINS: EDIT * FROM Schedule WHERE AllDates CONTAINS (CTXT(.vMonthlyDate)) This should be relatively safe with dates since one date "string" can't contain another one (which is a problem using this technique with variable length strings). You'll need to make sure your DATE FORMAT setting produces dates that exactly match the format used in creating the information in the table. You'd be a lot better off, however, converting that field to a separate table with the PK value from Schedule and one date value per row. -- Larry
