MS SQL Contains with blank spaces between words

Question

I have the following ms sql syntax to find all rows, which have these words:

select * from Expat_MA where CONTAINS (zusammen,'"*hans*" AND "*Level 4*"');

so this is my DB column, where the search is going through:

I just want the yellow marked row, but I get all 4 rows as result.

What's wrong ?

Do you have a full text index on the column? See [here](https://stackoverflow.com/questions/7510646/like-vs-contains-on-sql-server) — Peter Smith, Jan 31 '19 at 08:17
Then see some of the comments in the answer referenced above on the use of quotes and fuzzy matching. — Peter Smith, Jan 31 '19 at 08:22
Have you tried it without the wild cards? Is what you are searching for just `'hans AND "level 4"`? — Peter Smith, Jan 31 '19 at 09:16

score 0 · Answer 1 · answered Jan 31 '19 at 09:19

0

I think the wild cards are giving false positives. Try the following:

select * from Expat_MA 
where CONTAINS (zusammen,'hans AND "Level 4"');

answered Jan 31 '19 at 09:19

Peter Smith

score 0 · Answer 2 · answered Jan 31 '19 at 09:36

0

Maybe try this:

select * from Expat_MA 
where CONTAINS (zusammen,'"hans" AND "Level" AND "4"');

answered Jan 31 '19 at 09:36

Yingy

2 Answers2