Find value in group...

[tjb2]

I was wondering if there was an operator for looking for a group of values in field data. For example in T_SQL I can use the in operator...i.e. select emp_name in ('doe','smith','jones')...Is there a way to do the same in Crystal's Record Selection Formula editor. I have tried the following with no results:

{SECCODEasg.SECCODEDESC} in ("Staging";"Taylor";"Jones")

Thanks,
TJ

 

[TheBlondOne]

Try

{SECCODEasg.SECCODEDESC} in ["Staging","Taylor","Jones"]

HTH

 

[tjb2]

Thanks Steve!