Listing 1: Conditional Input to SUM() in a SELECT 
Statement That Uses CASE…END

SELECT
SUM
    (CASE
      WHEN FLD_ORDER_DATE='2003-08-10' THEN FLD_QTY
      ELSE   0
     END) 
AS F_TODAY
FROM …