Incorrect syntax near the keyword 'THEN'.

[ielmrani via AccessMonster.com]

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%'

 

[Duane Hookom]

You would have much better luck asking this question in a SQL Server news
group.

 

[ielmrani via AccessMonster.com]

I thought I was in SQL Forum. I'll post it in sql forum thank you.

You would have much better luck asking this question in a SQL Server news
group.

Hi Everyone,
I really tried to not post this question but I gave up. I tried brackets,

[quoted text clipped - 18 lines]

where CLAIM_HMASTERS_VS.CLAIMNO like '200601119%'