anandknr
Member
Hey all,
I have a query on CONTAINS operator.
Now, the query will show "y is word" and "y/n is a word" but I don't want the second record to be picked. That is, I want CONTAINS to do a perfect match; not a match from the list (y/n). Is this possible?
I have a query on CONTAINS operator.
Code:
define temp-table ttTest no-undo
field textFld as character format "x(30)"
index idx as word-index textFld.
/*
Entered below data into ttTest, each line each record.
hello world
hello planet
hello ???
y is a word
y/n is a word
*/
for each ttTest where ttTest.textFld contains "y" :
disp ttTest with frame rty 8 down title "output".
end.
Now, the query will show "y is word" and "y/n is a word" but I don't want the second record to be picked. That is, I want CONTAINS to do a perfect match; not a match from the list (y/n). Is this possible?