I am having trouble with a website search box that searches columns of HTML in a db to find a user-specified search argument. Here is the code: right now the search function is returning only strings which are independent of any other characters, and where
there are at least two occurrences of the word. I would like to be able to modify this code so that it returns a column if the sequence of characters occur no matter whether it is independent or not. For example: I need the search term "bounded"
to return pages where there is "boundedwindows" as well, or "<p>Bounded". I have limited T-SQL experience so I'm quite lost right now, please help!!
/****** Object: StoredProcedure [dbo].[SearchPagesByPage] Script Date: 09/22/2010 11:10:16 ******/
SET ANSI_NULLS OFF
SET QUOTED_IDENTIFIER OFF
ALTER PROCEDURE [dbo].[SearchPagesByPage]
View Complete Post