Hello,

I need to create a formula for a saved search where I can combine these statements into one formula:

CASE WHEN {shipmethod} LIKE '%FedEx%' THEN 'FedEx' END

CASE WHEN {shipmethod} LIKE '%USPS%' THEN 'USPS' END

CASE WHEN {shipmethod} LIKE '%UPS%' THEN 'UPS' END

CASE WHEN {shipmethod} LIKE '%LTL%' THEN 'LTL' END

I tired using OR but still getting expression errors.

CASE WHEN {shipmethod} LIKE '%FedEx%' THEN 'FedEx' 

OR {shipmethod} LIKE '%USPS%' THEN 'USPS' 

OR {shipmethod} LIKE '%UPS%' THEN 'UPS' 

OR {shipmethod} LIKE '%LTL%' THEN 'LTL' END