Incorrect syntax near the keyword 'THEN'

Giganews Newsgroups
Subject: Incorrect syntax near the keyword 'THEN'
Posted by:  ielmrani via SQLMonster.com (u212…@uwe)
Date: Tue, 22 Aug 2006

Hi Everyone,
I really tried to not post this question but I gave up.  I tried brackets,
parenth...etc but nothing worked.  I get this error message: Incorrect syntax
near the keyword 'THEN'.  Please help, I am learning SQL Server.
thanks in advance.
Ismail

use mis
select CLAIM_DETAILS_HCVW.INTEREST, CLAIM_DETAILS_HCVW.NET, CLAIM_HMASTERS_VS.

CLAIMNO,
'AMOUNT' =
CASE WHEN (CLAIM_DETAILS_HCVW.INTEREST IS NULL THEN '0' ELSE
CLAIM_DETAILS_HCVW.INTEREST + CLAIM_DETAILS_HCVW.NET)
END,

FROM CLAIM_HMASTERS INNER JOIN CLAIM_HMASTERS ON CLAIM_HMASTERS_VS.CLAIMNO =
CLAIM_DETAILS_HCVW.CLAIMNO

where CLAIM_HMASTERS_VS.CLAIMNO like '200601119%'

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200608/1

Replies