Making Advanced Search

Question

Dear Sir/Mam I am making an advanced search page from which a user can select a certain options and also one keyword textbox is there. I want that the Keyword text field should work in such a way that it should break up in literals and ignore the spaces commas and dots. If the keyword is in double or single quotes then it should understand it as single word for search. I am using C# and SQL Server. Can anyone help me in keyword field. How can I ignore the blank spaces and other characters from the textfield and also Character case. Thanks & Regards

Thirupathi v · Answer

Hi Do onething for overcome you problem. first you have to get the input from the user and using the string function we can find the commas Space and Dot. take separate separate word. and store it as array. and retire the words from array and you can execute your procedure or qurey using Like Statement.