'Unable to run contains query

I am unable to run a contains query in my sybase database.

Query:

SELECT * 
from party CONTAINS(nm_first,'ghjg')

On running the above query, I get an error message

"Table User-Defined Function 'party' not found" Error: 7306

Is this a bug? I am unable to find enough resources to find appropriate solution.

Any inputs would be appreciated.

sqlsybase


Solution 1:[1]

You can do this instead

SELECT * 
FROM party 
WHERE nm_first LIKE '%ghjg%'

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Brynjar Bragason

Related Questions