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 |
|
Hobbot
Starting Member
2 Posts |
 Posted - 2007-02-06 : 15:46:02
|
| Hi,We are facing a problem while passing a string containing the "&" character into Full Text search CONTAINS predicate. The records that do have this character are not being returned by the search.I'd like to raise two questions:1) Is there any special way to escape this character?2) Does FTS index it at all? We have tried all known (to us) ways of escaping like doubling the character, using char(38), using ESCAPE etc..Nothing seem to work. Any help would be appreciated.Thanks,Alex |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-02-06 : 19:20:10
|
| See http://support.microsoft.com/kb/923317 |
 |
|
|
Hobbot
Starting Member
2 Posts |
Posted - 2007-02-07 : 08:22:39
|
| thank you very much! |
|
|
|
|
|
|
Escaping bitwise in Full Text Search 2005