Hi All,

I have developed a recruitment software, where resumes are entered and when a vacancy arises , resumes are searched according to the criterias.

Now there is a field (skills c(200)) in the resume table. assume following records in the table

resume id skills
--------- -------
1 Visual Basic, Visual Foxpro, Sql Server, Excel
2 Sql Server, Visual Basic, Excel
3 Excel, Visual Foxpro, Access
4 Visual Basic, Sql Server
5 Sql Server, Access

Now on the search form there is a field for skills and if the user enters
Sql Server, Visual Basic

so the result set would be as

resume
*******
1
2
4

is there a way to write a query to get the following result successfully

Thanks in advance