> The vendor does have another solution, but it is VERY expensive. They charge by the finger print that is stored in SQL.
As usual.... good software demands high price....
SQL Server 2008 has a new datatype: GEOMETRY . It appears that this is the way for you to go, because there are no functions available for general images.
On the other hand you can FULL TEXT INDEX a word document if you associate it with a fingerprint in varbinary(max) data type column.
That means that you would have to enter the keywords into the Word document to be used for FULL-TEXT SEARCH.
The vendor does have another solution, but it is VERY expensive. They charge by the finger print that is stored in SQL.
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
The Best SQL Server 2005 Training in the World!