Select expert using "contains" in the formula 2

[JCook23]

CR10.0
SqlServer

I have a text field that may contain the word 'Expedite'. It is a small text field, but I want the report to only give records where poitem.fdescript contains 'Expedite'. How do I do this?

Thanks,

Jeff C.

 

[lbass]

Try:

instr({poitem.fdescript},"Expedite") <> 0

-LB

 

[JCook23]

Thanks LB, that was exactly what I needed!

 

[lkerr]

lbass,

Once again, your postings have saved the day - this formula is invaluable. I don't know why crystal can't just come up with a "contains" as an option in select expert.

LK

 

[bdreed35]

The only issue I would point out with lbass's solution is that it will not get passed through to the SQL statement.
Your better off using the the like pattern operator:

{poitem.fdescript} like "*Expedite*"

This will get passed down into the SQL statement making your report more efficient.

~Brian