I have a column which has full-text. When I execute this:
select * FROM myTable WHERE CONTAINS(myTable.colDesc, '"word"')
select * FROM myTable WHERE CONTAINS(myTable.colDesc, 'word')
It only finds one record. I have created multiple records with the word "word" in it and even created a duplicate record of the only record that is returned, however, still, only one record is returned. It's as if the records are not being added to the catalog. I also tried removing the catalog and the full-text attribute and adding it back. Still same result.
How do I fix this? :)