Help with Criteria Search

rbuser

I am newbie and in way over my head, however I have been able to build a
report, but need help refining the criteria. The report I built is for
inventory that has a description of "Bearing". The problem is that unless
the Description starts with the word Bearing it won't come up in the report.
If I use the "Like" operator I will get all inventory that begins with
Bearing but not inventory that "contains" the word Bearing if it doesn't
start with the word. Is there a way to use contains as an operator? Does
this make sense and if so can any of you help?

Sean
oseran@k-techav.com

digitalmetaphors

Contains is not supported as an operator in DADE. You can edit the SQL text
to add this ability manually, but you'll lose the query tools' functionality
when you edit the SQL text.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

I believe you could simply put %bearing% in your search criteria and it
would accomplish what you want.

digitalmetaphors

Yes, that does the trick. Thanks.


Cheers,

Jim Bennett
Digital Metaphors