Thread: Conditional statement in SQL Server query
View Single Post
  #2 (permalink)  
Old 10-29-09, 14:27
Wim Wim is offline
Registered User
  
Join Date: Nov 2004
Posts: 1,159
Code:
CASE WHEN (RIGHT(dbo.[000 Financial Reporting Map].[Mdse Sales], 5)) = 'Sales' 
          THEN dbo.GL_Account_Balances_All.[PTD Amt] * - 1
          ELSE '0' 
END
AS Sales_Dollars
__________________
With kind regards . . . . . SQL Server 2000/2005/2008/2008 R2 Earned beers: 13
Wim
Beware of bugs in the above code; I have only proved it correct, not tried it. -- Donald Knuth
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages
Reply With Quote