SQL USING CONTAINS FAILS

[kruckit]

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.

[TheOC]

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

[kruckit]

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.

[Abell]

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