Searching company name in Sql server Stored procedure
Posted on 2008-10-02
I need a search query stored procedure through which I can check a particular search criteria using keyword, particular word or some phrase. For e.g. my company name is "Experts exchange india pvt ltd". Now if I search with a keyword like "Experts" then it should show all the companies listing with keyword Experts in it. Now suppose I search with "Experts India ltd" then also it should show the same results with the companies with the same names listing. Can you please provide me some stored procedure or query for this?