I have a sql table with the columns "candidatename", "candidatelocation" and "resume".here resume column have only .docx type files in binary form. from front end I need to enter some words or phrases. My requirement is to get all the records which contain these words(or phrases) in .docx file("resume" column).. Here I'm not getting that how to search the given words with the binary type column.. I need this using asp.net with c# and sql server
You will need to install the Microsoft Filter Pack (http://support.microsoft.com/en-us/kb/945934) which will enable you to create a full text index on the varbinary column you are using to store the .docx document.