I'm implementing a full-text search in SQL Server but I have a doubt when searching for small words...
I use the CONTAINSTABLE(table, *, '"word1*" AND "word2*") for the all words search and CONTAINSTABLE(table, *, '"phrase") for exact search...
It works as expected, but when I search for "Windows 8" the all words search returns nothing cause the "8" is "dumped" and probably converted to NULL... The exact search returns all records with "Windows"..
Is there a way to solve this? "Tell" the full-text to index all words despite their size?
If you need to work better, try working less...