multiple Like statements in crystal 2008

[sap1958]

I am trying to avoid hardcoding a series of job titles as follows
chair
chair-pediatrics
associate director
assistant director
director
vp
vice president

You can see the various scenarios here. Ay ideas for a like statement that I can use in record select to get these and similar job titles without hardcoding. I have several more that are similar to these mentioned.

 

[Turkbear]

Hi,
How are these even remotely similar?

try something like:

{Table.Title} LIKE ["*chair*","*director*","*vp*"]

It is case-sensitive so if mixed cases are involved you may need to use ( but only if needed, it can slow things down):

LowerCase({Table.Title} LIKE ["*chair*","*director*","*vp*"]





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