Posted by ielmrani via SQLMonster.com on 08/22/06 16:20

That's it. Thank you so much.
Jack Vamvas wrote:
>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
>___________________________________
>
>> Hi Everyone,
>> I really tried to not post this question but I gave up. I tried brackets,
>[quoted text clipped - 20 lines]
>> Message posted via SQLMonster.com
>> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200608/1

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

• Next in forum: adding unique keys
• Prev in forum: Re: 6.5 master database syslogs full
• Thread view: Re: Incorrect syntax near the keyword 'THEN'

[Reply to this message]