Ok guys.. Thinking caps: ON Have an nvarchar field in the database with data like: 1,3,9,12,2,51
Have a formfield with single number (not digit) data, like: 1 or 12 -- single whole numbers, maybe more than 1 digit. Now, would like to do something like this: SELECT EmailAddr, RecipientID FROM SupportEmailRecipient WHERE SubjectID IN ('#FORM.SubjectID#) It ain't workin... Need to see if the data from the formfield is IN the data in the table's record. Help? TTAIA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4