>> 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) Accept that if you left join dream, you'll get every word from the dictionary -- I was under the impression ( possibly mistaken ) he was looking for only words appearing in the dream text ... s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
