SQL Server Performance

containstable single char

Discussion in 'General DBA Questions' started by brimba, Jan 3, 2004.

  1. brimba New Member

    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 herehttp://www.sql-server-performance.com/advanced_search.asp 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!

Share This Page