Stem Operator ($) does not work
Hello:
We are on Oracle 10g and I cannot seem to get this operator to work. (I am following the documentation at http://download-west.oracle.com/docs/cd/B10501_01/text.920/a96518/cqoper.htm#14499).
I get the following:
select count(*) FROM local_appls WHERE CONTAINS(project_title, 'isoflavone') > 0;
COUNT(*)
----------
54
select count(*) FROM local_appls WHERE CONTAINS(project_title, 'isoflavones') > 0;
COUNT(*)
----------
139
select count(*) FROM local_appls WHERE CONTAINS(project_title, '$isoflavone') > 0;
COUNT(*)
----------
54
Shouldnt the final query return something between 139 and 193?
thank you in advance for any advice.
Regards,
Harvey