I am having trouble using the CONTAINS function in sql
server(enterprise manager). I am typing the following:
Select *
FROM mytable
WHERE CONTAINS(myfield,'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
Server]Statement(s) could
not be prepared.
According to the T-SQL reference on msdn this is a supported function?
Am I typing something incorrectly? If this is not supported, is
there an equivalent to this function? In my field I have some comma
delimited values ie 'apple,orange'. So I need to be able to discern
which records contain orange. The LIKE keyword doesn't seem to work
for this scenario. Any help would be greatly appreciated.