July 26, 2013 at 3:02 pm
I'm using CONTAINS to search for a string or word. If I search for Hobby is it possible to make it search for Hobbies also, which is the plural of Hobby? FREETEXT seems to be doing this but I want to do it with CONTAINS because it will make me search with an AND clause. FREETEXT using OR clause which I don't need.
For example if I do below search for 'John AND Hobby', I would like to get strings that have both John and Hobby / Hobbies
WHERE contains (*, 'John AND Hobby' )
July 26, 2013 at 3:20 pm
sql server developer (7/26/2013)
I'm using CONTAINS to search for a string or word. If I search for Hobby is it possible to make it search for Hobbies also, which is the plural of Hobby? FREETEXT seems to be doing this but I want to do it with CONTAINS because it will make me search with an AND clause. FREETEXT using OR clause which I don't need.For example if I do below search for 'John AND Hobby', I would like to get strings that have both John and Hobby / Hobbies
WHERE contains (*, 'John AND Hobby' )
You need to use CONTAINSTABLE to do proximity searching. Once the query is set up correctly with CONTAINSTABLE it will return the results with a column showing the ranking of the search results. There are many options for setting the various proximity variables.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy