Community discussion forum

searching specific records in varbinary field

• • Reply

  2 years ago

  by shet_ravi

  Ravi Shet

  Mumbai, India

  Joined 3 years ago

  Hello everybody

  I have saved 3 msword documents into 3 different records in a table
  containing 2 columns namely ID and Docs whose datatypes are int and
  varbinary respectively. How can i search for that record that contains
   a specific text without extracting the word file from the table.
  Example-- i would like to retrieve all those records
  which contain the text 'SQl Server' in the word document file saved in the Docs field. The file to be stored in the docs field can only be a word document. Is it possible to do such a search. Please help me.
  
  
  
  
  

  Report abuse
• • Reply

  2 years ago

  by frankkerrigan

  Frank Kerrigan

  , United Kingdom

  Joined 2 years ago

  What you can do is have a text field where you put a text only version with no formatting. Newer versions of SQL server can handle XML field and new versions of MS Word are XML base so you may be able to do something with that.

  You may also want to look at Index Services which can provide full text search db via the file system.

  Report abuse