I want to return search results in a format similar to:
... to search the database you must do this in order to get it to work. ... this database isn't designed correctly....
As you would see in Yahoo. Based on the word(s), the search results would keep so many words to the left and right of the searched word(s). Is this possible to do in SQL Server in a stored procedure? Can you alter the results of a SQL query for a specific term?