Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
SQL Statement for combining LIKE conditions
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
0