select case statement in formula

[sorchard2000]

Crystal 8.5
SQL server

On a select statement, can I add LIKE into the statement so that I can use a wild card for a search?

Here's what I have:

Select {psmpro.proname_abbr}
Case 'MVR', 'CABG', 'AVR' : 'Open Hearts'
Case 'ACD*', 'KYPH*', 'LUMBAR*', 'POSCER', 'POSTLUMBAR' : 'Spinal Procedures'
default: 'Error not defined'

This results in it NOT finding any procedures with ACD in the abbreviation.
I want it to find any procedure with ACD in the procedure abbreviation and call it a "Spinal Procedure".
How can I do this?

Thanks all you smart people!

 

[synapsevampire]

Convert to an IF:

if {psmpro.proname_abbr} in ['MVR', 'CABG', 'AVR'] then
'Open Hearts'
else
if {psmpro.proname_abbr} like 'ACD*'
or
{psmpro.proname_abbr} like 'KYPH*'
or
{psmpro.proname_abbr} like 'LUMBAR*'
or
{psmpro.proname_abbr} in ['POSCER', 'POSTLUMBAR'] then
'Spinal Procedures'
else
'Error not defined'

-k

 

[sorchard2000]

Thanks for your help! It worked!