0

I currently have full text search implemented. FTS currently segments if there's dashes. I was wondering if there's a way to NOT segment for dashes.

record 1 - Apples,Pears,Blood-Oranges

Record 2 - Oranges

I want to return all records where the field doesn't contain Oranges. In the example it should only return record 1 but it turns no records.

SELECT taglist, * 
FROM contacts 
WHERE NOT Contains (taglist, '"Orange"')
Master
  • 2,038
  • 2
  • 27
  • 77
  • Note that tables have _rows_ and _columns_, not records or fields. – jarlh Nov 02 '21 at 18:55
  • Does this answer your question? [Ignore Dash (-) from Full Text Search (FREETEXTTABLE) search column in SQL Server](https://stackoverflow.com/questions/47532557/ignore-dash-from-full-text-search-freetexttable-search-column-in-sql-serve) AFAIK It's not possible – Charlieface Nov 02 '21 at 20:56

0 Answers0