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 |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2006-09-19 : 07:16:30
|
| hi,i am working electronic document management system store documents word excel adobe in database in binary format in sql server 2000.i have implemented full text search on table on binary field id.facing problem in searching when search on single work work fine but when give pharse then fail 'web hosting'.table structure [doc_manage_main]snofile_namefile_keywordsfile_info [image] created full text on this filedSELECT doc_manage_main.sno,doc_manage_main.file_name, document_type.doc_type, doc_manage_main.create_date, doc_manage_main.user_id, doc_manage_main.file_ext FROM doc_manage_main INNER JOIN document_type ON doc_manage_main.doc_type_id = document_type.sno WHERE (file_name LIKE '%web%') and doc_manage_main.user_id = 'abc ' OR CONTAINS(file_info, 'webhosting') when i enter 'web hosting' its not work so pls tell me how to implement full text quey with pharase.thanks |
|
|
|
|
|
Full text search binary data