Boolean Search - ASP.NET & SQL Server ---500 points
Posted on 2004-09-04
Currently I have search functionality on my ASP.NET pages, which does a "LIKE" search against multiple tables, multiple fields. We need to change this functionality to support Boolean search. Say, the user would like to type "oranges AND apples OR grapes NOT peaches" in the search text box, where AND, OR, and NOT are considered Boolean identifiers. Note: Fulltext search isn't an option. So I'm trying to parse the search string in the stored procedure to construct the WHERE CLAUSE. Remeber search is on 5 tables over 50 columns...
Experts please give some stored procedure script to create WHERE CLAUSE based on the Boolean Search String.