You may also be able to do something like ```CASE WHEN SUBST NetSuite Professionals #suiteflow

You may also be able to do something like: ```CASE...

jcribb

05/29/2018, 8:29 PM

You may also be able to do something like:

Copy code

CASE WHEN SUBSTR({companyname},1,1) BETWEEN 'A' AND 'M' THEN 'Eli' WHEN SUBSTR({companyname},1,1) BETWEEN 'N' AND 'Z' THEN 'Andrea' ELSE 'TAMMY' END

Also switching to their employee id's