Can anyone help please?

 

I need to filter out certain codes from STOCKDYN.PRDGRP.

 

Product group values are always 2 characters.

 

eg; CA, CB, CC, CD, C1, C2, etc

 

 

I need all product groups that startwith  C,  H,  L &  M

 

but dont require CC or MA to MZ.

 

So far I have this formula:

 

if {STOCKDYN.PRDGRP} in ["CC"] then FALSE else
left({STOCKDYN.PRDGRP},1) = ["C", "H", "L", "M0", "M1", "M2", "M3", "M4", "M5", "M6", "M7", "M8", "M9"]

 

I think the issue im having here is the LEFT,1 formula.

 

Can i amend the code to read:

 

left({STOCKDYN.PRDGRP},2) = ["C@", "H@", "L@", "M0", "M1" etc... ?

 

 

 

I know '@' refers to ANY CHARACTER in SQL commands and wondered if it was the same in Crystal reports. if not, what is an ANY CHARACTER symbol in crystal Reports?

 

or can anyone suggest a really easy way to do this?

 

 

 

Thanks in Advance.

 

Sample:

left({STOCKDYN.PRDGRP},2) LIKE ["C?", "H?", "L?", "M0", "M1"]

or

{STOCKDYN.PRDGRP} LIKE ["C*", "H*", "L*", "M0*", "M1*"]