you can't you add the properties you want to search on in other areas of the table that point to the varbinary i.e.
products
ID int
data varbinary
author varchar(max)
date datetime
tags varchar(50)
Starr Duskk
ASKER
Sorry, yes, I intend to search using a SQL Query, not client side.
We have found we can search these results if the file is csv and return rows, and some pdfs show up, but other pdfs do not find the asked for data.
Pavel Celba
Some PDFs do not contain text info in open text and/or they can have just image format. In such case you would need OCR to read them which is hard to implement on the SQL Server.
products
ID int
data varbinary
author varchar(max)
date datetime
tags varchar(50)