containstable single char | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

containstable single char

Hi! I have this code today: …CONTAINSTABLE(favourite,[text],@searchStr)… I want to be able to search for all word, short or long and also multiple words. example or strings i would like to send "s"
"yukon database"
"sql-server" The advanced search engine here does exactly what I want.. If you example search for "s" it return all resuls that contains an s. I have tried to edit the noise.* file with no luck… I want to use containstable to be able to get the rank position… Could also be cool if the user could choose if we should split the word as have to include all words, or any of them… Thanks!