Use LIKE CASE WHEN with AND

[scarmie]

How can I use an And statement in cognos with LIKE CASE?
e.g.:

[Country] LIKE CASE
WHEN (?SelectedCountry? = 'EUROPE') THEN ('%FRANCE%' AND '%GERMANY%' AND '%SPAIN%')

the above is not correct, can someone help me by telling what's wrong in the above?

thanks!

 

[blom0344]

Everything.. That is not how a CASE expression works. The THEN part should return a value, not a logical expression.

What are you trying to achieve?

Ties Blom