Is "time" a reserved word in the %CONTAINS function?
When I run the following SQL query, I get 0 matching results
SELECT ID, text FROM Test.Sentence WHERE text %CONTAINS('time') OR text %CONTAINS('time ') OR text %CONTAINS(' time')
However, when I run a query where the search string contains words other than "time" alone, it returns the expected matching results