Haven't tested it because no data... but this should work SELECT ID, Name,
CASE SUM(Revenue)
WHEN 0 THEN 'NO Revenue'
ELSE 'Has Revenue'
END
FROM MyTable
WHERE [Start Date] = '2008-08-01' AND Name = 'myName'...
--Jeff Moden
Change is inevitable... Change for the better is not.