> I don't think that is a very good solution. Not only can this not use > any indexes, it will also not match "Friends Season 7 - Complete Series" > because the order of the words doesn't match.
I was originally breaking the string and doing several 'and's. I do need to look into "Full Text Indexing" but I haven't used it before, any good reference sites as a starting point? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281116 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4