Home Forums SQL Server 2005 Development Are there alternatives to this SQL logic RE: Are there alternatives to this SQL logic

  • October 22, 2013 at 1:33 pm

    #1660675

    How about using IN?

    SELECT CASE

    WHEN RTRIM(Customer.Source) IN ('CREDITNEW','CREDITOLD','TOC') THEN 'CREDIT'

    WHEN RTRIM(Customer.Source) IN ('DEBIT') THEN 'UC DEBIT'

    WHEN RTRIM(Customer.Source) IN ('DEBITOLD','DEBITNEW','TLC') THEN 'DEBIT' -- Defined orginally with space, Crystal uses the space version for logo

    ELSE 'UNDEFINED' -- Default logo

    END AS CompanyName, CompanyId, TermsofUse

    FROM Customer

    Edit: Formatting


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.