Posted by Jack Vamvas on 08/22/06 15:42

Try putting the ELSE part out of the brackets
i.e
CASE
WHEN (CLAIM_DETAILS_HCVW.INTEREST IS NULL THEN '0' )
ELSE CLAIM_DETAILS_HCVW.INTEREST + CLAIM_DETAILS_HCVW.NET
END
--
----
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
Make SQL Server faster - www.quicksqlserver.com
___________________________________


"ielmrani via SQLMonster.com" <u21259@uwe> wrote in message
news:65279dafaa057@uwe...
> 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
>
>

[Back to original message]