• We sometimes create our own "full-Text" indexes instead of using SQL's Full-Text feature because we have non-standard requirements...

    I'll create a Multi-Statement table-valued function that parses a string parameter into a table of terms.

    I'll Cross Apply this function to a database table passing the column (or appended columns) I wish to parse into a full-text index, outputing the resultant UDF-generated table along with the primary key of the database table row.

    I'll index this table appropriately, and wallah!, home-grown full-text index...

    Tastes great... less filling...

    I leave the exercise of integration up to you to help burn the calories gained from ingesting this full-bodied brew!



    PeteK
    I have CDO. It's like OCD but all the letters are in alphabetical order... as they should be.