Thanks for this article!
I have one question based on creating the sample data. I got this warning when I ran the code:
Warning! The maximum key length is 900 bytes. The index 'IX_LIKETest' has maximum length of 1000 bytes. For some combination of large values, the insert/update operation will fail.
(14 row(s) affected)
Do you get this warning, too? I figure it doesn't affect anything regarding the wildcard topic you discussed, but I am just curious about this error message.