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 |
|
ssray
Starting Member
5 Posts |
 Posted - 2007-07-06 : 15:01:35
|
| I have Sql server 2005 SP2.I enabled it for Full Text search. Substring search where i enter *word* doesn't return any row.I have a table testtable where description has word Extinguisher.If i run a query with *ting* it doesn't return any row.select * from testtable where contains(description,'"*xting*"') ;But it works if i do select * from testtable where contains(description,'"Exting*"') ;The Full text search document says it supports substring search.Is it an issue with sql server 2005?Please help. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-06 : 16:17:09
|
| How did you enable full text index? Did you create catalog? Did you populate it? |
 |
|
|
ssray
Starting Member
5 Posts |
Posted - 2007-07-09 : 08:19:08
|
| Yes we do use catalog and we populated it . |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-09 : 11:03:19
|
| What does catalog properties say? Got word counts there? |
|
|
|
ssray
Starting Member
5 Posts |
Posted - 2007-07-10 : 08:27:47
|
| We just create catalog and populate it by these commands.sp_fulltext_catalog 'cat1', 'create'sp_fulltext_catalog 'cat1', 'start_full' |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-10 : 10:43:56
|
| Right click on the catalog in ssms and go to properties, what are item count, unique key count and catalog size? |
|
|
|
ssray
Starting Member
5 Posts |
Posted - 2007-07-16 : 11:40:28
|
| Do you have any idea why catalog will affect the search? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-16 : 22:16:27
|
| It tells you if full text index works or not. |
|
|
|
|
|
|
Full Text Search- Substring search not working