How to Filter Lines Containing any one word...

[4hrlife]

I am working with Crystal 8.5 and I have a long list of products, however, I only want to display products that contains the word "LOTION"...example below:

Skin-So-Soft Lotion
Mineral Lotion
Lotion To Sooth
Mineral Oil
Cocoa Butter Oil

I want to display the line items that contain the word 'lotion' only! Thank you!

 

[lbass]

Use a record selection formula like:

{table.product} like "*Lotion*"

If the word could be upper or lower case, create a SQL expression {%product}:

ucase(`table`.`product`)

And then use a record selection formula like:

{%product} like "*LOTION*"

-LB

 

[Turkbear]

Hi,
Some clarification and information please:

What Database is being used?
What connection method?

By I only want to display
do you mean only show or only retrieve those records?

Depending on your database, a use of the LIKE clause with wildcards should enable you to do either..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[4hrlife]

Thanks, LB

That worked!