text searching a field like google
Posted on 2008-06-15
i want to be able to search an ntext field similar to the way search engines work. maybe a stored procedure that would take as a parameter a search string and return a select statement of those that matched
example: a search for 'red orange apple' --> would match on a ntext field with the phrase "the recipe calls for a red apple, but you could substitute an orange"
ideally it would also handle OR and quotes as well (just like google)
im sure this has been done before. are there some examples already written?