I have a table with varbinary datatype (file stream enabled) column which store pdf files as binary , form that i can get result as which of file have 'invoice' word using following query.
SELECT * FROM FileStore WHERE CONTAINS(Document,'invoice')
Here "Document" is varbinary column which store pdf and word files as binary.
From this i want to get words which appear how many times, i mean number of occurrences.
E.G: In one of the pdf got 'invoice' word 5 times , so want to count how many time word appear in that table using query,
Note: i am asking in varbinay datatype, not for nvarchar datatype.
What I have tried:
I tried with string can, but from binary cant found solution.
Any solution much appreciated.
Thanks and Regards