Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-20 : 08:33:08
|
| Charanjiv writes "Hi I ma loading docs onto my DB table. What i want to do now is to be able to search these doc for text in them. The file types are the usaul word docs , pdf text files, excel etc .. Can i search the column and get a list of say all docs which have hte worD "SQLTEam" in them. TIA Charanjiv" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-20 : 09:30:52
|
| If you are using SQL 2000, you can use full-text indexing to index those columns are use CONTAINS and FREETEXT to query them. You'll need to read up on "full-text indexing" in Books Online, I don't know the details.If this is not an option, what I would recommend you do is to NOT store document files like Word or PDF in SQL Server, ESPECIALLY if you want to search their contents. Store them as files instead, and store the path and filename in your database, NOT the actual contents. If you store them as files, you can use Windows Indexing Service to index them for full-text searches. |
 |
|
|
|
|
|
Search the uploaded docs in hte DB