CODEWITHSUNDEEP
sql-serverfull-text-searchcontainsfreetextformsof
Ranveer
Ranveer

Reputation: 11

when i write MS SQL full text search query for return all matches, then it give me not correct output

this is my query:-

select * from dbo.zones where freetext(name, 'test');
 select * from dbo.zones where contains(name, 'formsof(INFLECTIONAL, test)');

this give me result of- test, testing, tested

Select * from dbo.zones where contains(name, 'test');

this query only give me test result.

I am trying to get record which have "test" string like, "this is a test case".

so my query needs to find "test" string in "this is a test case" values also.

suppose i have a string in db column like "this is new generation", then i write a query like-

select * from dbo.zones where contains(name, 'formsof(INFLECTIONAL, gen)');

then this query not returning result of "this is new generation", i need that if i pass "gen" for searching then this give above result

Upvotes: 0

Views: 140

Answers (0)

Related Questions