I have an application in which a user can typ in a word or words and SQL Server finds the right rows.
I've used FREETEXT because I want it to be possible that the user can type multiple words to search on (with CONTAINS I have to convert that string to 'Word1 OR Word2').
But I just found out that with FREETEXT, if I search for example for 'Projectnummer' and I type 'Project', it will not find it. I cannot use a * in FREETEXT or an % to achieve the desired result.
How can I use FREETEXT so that I'm able to find words on a partial criterium and still search for multiple words