Conditional statement in SQL Server query

NotaDBGuru · #1 (**permalink**) 10-29-09, 12:30

I have never written a formula in a SQL Server query before, just in Access and Oracle...

I have an "iif" satement that works great in access and I am attempting to move it to SQL Server. I have learned in these forums to use "Case" instead of "IIF"

Now I am stuck.

I am running into errors when I run the following in my query:

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

The errors are: incorrect syntax near the word THEN

Any help would be greatly appreciated...

Wim · #2 (**permalink**) 10-29-09, 13:27

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

NotaDBGuru · #3 (**permalink**) 10-29-09, 14:07

Thanks a lot!