Full text search on xml datatype

hovsbpixni

New Member
I am working on an application, in which I am parsing the resumes by using third party. That third party return me the response in form of xml. I am storing whole xml in single column. Every time number of nodes will be different depend upon the resume supplied.Now my requirement is to perform fulltext or normal search on this xml data type column. I also need to fetch candidates first name, last name, email and some other important information. My question is how I can peform search on such columns where I don't know the node names.
 
Back
Top