SQL Server - Multi-Column substring matching
- by hamlin11
One of my clients is hooked on multi-column substring matching.
I understand that Contains and FreeText search for words (and at least in the case of Contains, word prefixes). However, based upon my understanding of this MSDN book, neither of these nor their variants are capable of searching substrings.
I have used LIKE rather extensively…