Che Vilnonis wrote: > Thanks Damien. I was stuck on using the IN clause which was not working. I > switched to LIKE and it works. Actually, it works w/o the commas and only > one where clause. > > i.e. >- WHERE emaildates like '%#todaysDate#%' >
Be careful with that, because if your data is... '12/1/2006,11/1/2006,10/1/2006' then LIKE '%1/1/2006%' will be true and LIKE '%2/1/2006%' will be true Stay away from the delimited lists in columns...that data should be in a separate table where you can actually have a date datatype that doesn't allow invalid dates to be input, as well as making the comparisons very clear cut. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265779 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
