> I'm not a SQL wizard and am doing this off the top of my head, but I'd try > something along the lines of > > select word from dictionary where > (select dream from dreams where dream_id = #dreamid#) > like ('%' + word + '%') > > But, again, that's off the top of my head. >
What you mean is : SELECT dictionary.word, dictionary.definition FROM dictionary LEFT JOIN dream ON dreams.dream LIKE '%' + dictionary.word + '%' Which is what Isaac's got in his stored proc... ;o) Regards Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.