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 |
|
nroose
Starting Member
3 Posts |
 Posted - 2004-09-21 : 16:53:52
|
| Is it really true that the contains function does not work unless the table you are looking at is full-text-indexed? That sucks, and it is not in the documentation for CONTAINS.Also, as far as I can tell, MSDE does not support full-text indexing. Is that correct? That sucks too, even more so that Contains requires full-text indexing, because I am developing using MSDE, and I would like to use Contains and full-text indexing.Is it really this bad?Thanks. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-09-21 : 17:11:21
|
| yes, you are correct.-ec |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-22 : 13:20:14
|
| Probably a daft question, but I don't suppose LIKE will do instead of CONTAINS?Kristen |
|
|
|
|
|
|
CONTAINS and MSDE