HomeActive Query BuilderHow can I create a criteria with a function contains()?

How can I create a criteria with a function contains()?


Hello,

I need to create a query like this, for Oracle, using fulltext research:

SELECT ID FROM SCOTT_TEXTS WHERE CONTAINS(TEXT, 'HELLO') > 0;


How can I create such a criterion "CONTAINS(TEXT, 'HELLO') > 0", with my Active Query Builder?

Thanks.

Rosière Fontaine | email
May 22 2009, 11:12 AM
You should put the "CONTAINS(TEXT, 'HELLO')" into the Expression column and the "> 0" into the Criteria column.
Sergey Smagin | email
5 days, 13 hours since original post
This topic is closed