Hi
i have one table in sql server called student_info
in this table keyskills column contain value like below
'c,c++c#'
'c++,c,c#'
'c,c++,c#,asp.net'
etc
i want to search the student information based on keyskills like naukri
1.Any keyskills from textbox1
2.All keyskills from textbox2
3.Except keyskills from textbox3
when i enter c,c++ or c++,c in textbox1 then it will dispaly all the student whose have c,c++ keyskill
how to achieve this.
Amit ChoudharyPosted Dec 27, 2012, 11:24 AM
Check out these articles:
http://msdn.microsoft.com/en-us/library/ms142571.aspx
http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/