C
cverbiest
Guest
During one of the Exchange sessions I asked for an enhancement for the contains condition to allow for * at the start of the pattern. Gus mentioned that no enhancement was necessary because there is a trick to achieve that with the current word-indexes. Unfortunately I forgot to ask what that trick is. Example, I want to find William but I'm not sure it is Bill or William in the database ( https://www.quora.com/Why-is-Bill-a-nickname-for-William ) so I'd like to search for where name contains "*ill*" This gives a "QBW syntax error - an asterisk (*) is allowed only at the end of a word. (4686)".
Continue reading...
Continue reading...