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 |
|
Andrew Shaw
Starting Member
1 Post |
 Posted - 2003-03-25 : 08:14:59
|
| I'm trying to find a way to search for the strings 'C++(C plus plus)' or 'C#' in an indexed table. The table contains 70'000 word documents. The server runs Windows NT4 sp6a and SQL 7 sp4.I've removed the letter 'c' from the noise file which enables me to search for that letter but it seems that the indexing engine considers the characters '(plus)' and '#' as operators even if they are declared as strings ... declaring a variable and assigning the string to it changes nothing.I've read in other forums that it could be a limitation of the indexing engine of SQL 7 and 2000 and would like to know if there is a work-around solution.It also seems that this forum considers the plus sign as a blank character ;-)Andrew ShawIT ManagerTalisman Software Holding SA |
|
|
|
|
|
Searching for 'C#' in indexed table