Case Statement with a wildcard operator?

[tman135]

Is it possible to use a case statement in Crystal 8.5 with a wildcard operator?

For example,

SELECT (TABLE.FIELD)
CASE LIKE '%VHS%' AND LIKE '%GB%' : 50



Thanks for any advice

 

[mbarron]

Are you talking in the record selection area ("menued" at Report / Edit / Edit Selection Formula > Record...)

You could use:
{table.field} like ["*VHS*","*GB*"]

or you could use the record selection expert and choose "Is like" for your field.

Mike