> 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.
