• You could use a "simple case" expression (in contrast with the searched case expression you wrote).

    SELECT CASE RTRIM(Customer.Source)

    WHEN 'CREDITNEW' THEN 'CREDIT'

    WHEN 'CREDITOLD' THEN 'CREDIT'

    WHEN 'TOC' THEN 'CREDIT'

    WHEN 'DEBIT' THEN 'UC DEBIT'

    WHEN 'DEBITOLD' THEN 'DEBIT' -- Defined orginally with space

    WHEN 'DEBITNEW' THEN 'DEBIT' -- Crystal uses the space version for logo

    WHEN 'TLC' THEN 'DEBIT'

    ELSE 'UNDEFINED' -- Default logo

    END AS CompanyName, CompanyId, TermsofUse

    FROM Customer

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP