|
-
Nov 23rd, 2021, 09:15 AM
#3
Re: SQL Server fulltext - Search failures
 Originally Posted by Zvoni
1) Since you're using double quotes (simple_term = exact match case insensitive), have you tried the LIKE-Operator instead? Maybe lower casing everything before comparing
Just to test if the results are the same resp. "wonky"
2) Since "hist" is an int, have you tried hist=0 (or-ed with Is Null)? Maybe someone changed the default-value
If I rebuild and repopulate the problem goes away.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|