Case statement help

[michaela18]

How can I write a case statement for:

nullif(CONCAT((SUM(Sales.sales)/SUM(sales.volumn))*100,'%'),0) AS ATC ?


I want to pull 'ATC' but with different where statements. But I don't know how to put that as a case statement like nullif ( case when ???? I have no idea.

 

[bborissov]

SELECT NULLIF(
              CASE WHEN Condition1 
                        THEN Result1
                   WHEN Condition2
                         THEN Result2
               ...
               ELSE DefaultResult END, 0) AS ATC

But that is only if you use that expression in Fields part of the query. If you want to use it in WHERE part then you should skip AS ATC part


Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.