Today’s tip is from Marius Agur Hagelund “Viking” Lind (actually, I’m confused, perhaps it’s Marius “Viking” Agur Hagelund Lind?). Got a tip of your own? Send it to firstname.lastname@example.org. Cannot use CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed Mean SQL Server If you’ve ever got this error […]
Tip #929: Why leading wildcard is not default
Our original wildcard tip has generated some interest and I thought that this very good question from Chase deserves a separate post rather than an inline reply: I do not understand why this isn’t a native action of searching. There are multiple reasons why leading wildcard is not a default. I often use “what would […]
Tip #926: How to find space
We did talk about wildcards and using some unorthodox search techniques before. But today’s tip is not a revision but rather an extension. In one of the projects we had the need to find all contacts whose last names contain spaces (if you must know, that’s because last names were used as a base for […]
Tip #178: Do you know what a wildcard is?
From time to time I discover that not everyone on this planet knows what the wildcard is or how to use it. Just the other day I overheard a conversation between two [reasonably advanced] business users that went along the lines: I was looking for this guy in our CRM but couldn’t find him. I […]