Word-index Not

[Grant Holman]

Is it possible to NOT a CONTAINS clause on a WORD-INDEX?

e.g. where field contains 'cat' but NOT 'dog'

Thanks

 

[Osborne]

It might be a bit slow but I suppose you could do something like this:

FOR EACH customer NO-LOCK WHERE customer.Comments CONTAINS "cat" AND
  INDEX( customer.comments, "dog") = 0:
END.

 

[RealHeavyDude]

I believe it will definately be slow since the compiler can't bracket on an index and it will cause a table scan to resolve it.

I would have it this way:

for each customer no-lock where customer.comments contains "cat":
  if index ( customer.comments, "dog" ) = 0 then do:
    /* Your stuff */
  end.
end.

Heavy Regards, RealHeavyDude.

 

[Grant Holman]

Thanks both for your replies.