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
Riyaz Patanwala
I. T. Programmer
Al Jaber Energy Services L.L.C.
P.O.Box 47467
Abu Dhabi, U.A.E.
Tel - +971 2-502-1644
Fax - +971 2-554-6106
Cell - +971 50 358-0229
Email -
riyaz.patanwala@ajes.aeWebsite -
www.ajes.ae