James Smith wrote: > As a last resort this procedure does the following... > > SET @searchTerm = '%' + REPLACE(@searchTerm,' ','%') + '%'; > .. > .. > .. > AND (Title LIKE @searchTerm OR ArtistName LIKE @searchTerm) > > So that is someone searches for 'friends series 7' it is first turned into > '%friends%series%7%' which will match the title 'friends complete series - > 7' (for example).
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. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4