SQL USING CONTAINS FAILS

Question

I have a simple SQL query that I am trying to do that fails.  I have done very little SQL coding and do not know why this fails.
Tied to an MS SQL Server box with the this SELECT statement:
select Test.*
from Test
where contains(refer,'Test')

When I test the query I get an ERROR OPENING error message.

If I remove the where clause it works fine.

Abell · Answer

any resolution? I am getting errors with contains in the SQL editor also

kruckit · Answer

That gives the same error.  When I try to switch to the Visual Query Builder I also get a message that it is an invalid SLECT statement.  The other version didn't do that, but still threw an error when run.

TheOC · Answer

hey @kruckit

Dont have an sql instance spun up to test, but i believe you would want:

Select Test.* from Test where refer CONTAINS 'Test'

Hope this helps,
TheOC