0

Project table Name columns contains this data:

  1. USA Russia England Canada
  2. Canada

Query:

SELECT name 
FROM project 
WHERE FREETEXT(name, '"USA Canada"')

Result: the query returns both rows.

Expectation: the query should only return 1 row containing USA and Canada

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
hsn
  • 31
  • 4

0 Answers0