I am having trouble using the CONTAINS function in sql
server(enterpri se manager). I am typing the following:

Select *
FROM mytable
WHERE CONTAINS(myfiel d,'mystring')

This returns the error:

Query Designer encountered a MS Design Tools error:
ODBC error:[Microsoft][ODBC SQL Server Driver]'CONTAINS' is not a
recognized
function name.[Microsoft][ODBC SQL Server Driver][SQL...