jcribb
CASE WHEN {companyname} BETWEEN 'A' AND 'MZZZZZZ' then 'Eli' WHEN {companyname} BETWEEN 'N' AND 'ZZZZZZ' then 'Andrea' ELSE 'Tammy' END