CODEWITHSUNDEEP
sqlsql-server-2008freetexttable
R Grove
R Grove

Reputation: 31

SQL Server FREETEXTTABLE minimum length

I'm getting no results when using a FREETEXTTABLE query when my search string is only 3 characters in length (when its 4 it returns results). Below is the code I'm running when it returns results, but if I change my search term to 'gol' it returns no results.

DECLARE  @strSearchWords varchar(500)   = 'golf'
SELECT sku, title
FROM products AS p INNER JOIN
    FREETEXTTABLE(products, title, @strSearchWords) AS search_table
    ON p.product_id = search_table.[KEY]
ORDER BY 
    search_table.RANK DESC

I'm sure its most likely a database setting but I've not been able to find anything referencing it. or is it just too broad a search for it to find any matches?

Upvotes: 1

Views: 202

Answers (0)

Related Questions