James Smith wrote: >> 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?
Full text searching is so implementation specific that you might as well start with the manual. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by AdobeĀ® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281140 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4