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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-06-16 : 08:44:08
|
| Neil writes "I'm using CONTAINSTABLE to conduct searches.I've set up the catalog and everything is fine except my client has decided to search for % on its own and of course the thing bombs out each time. 67% etc as a query works fine.I've tried CONTAINS and FREETEXT with the % escaped [%] and still no luck and all sorts of combinations in between.I'm lost trying to get this query to run and so would appreciate any advice on how to do this OR if you could give me the location of the ignored word file. I'm using SQL 2000 standard ed. and have found all the ignored word files I can, but none of them contain the %Regards" |
|
|
|
|
|
Full text search on ignored words