negitve case

Question

    

how do I do this in tsql?

    CASE tradeType not 'VANILLA' THEN banksidePremium END AS [BANK PREMIUM]

Answer 1

Nearly there, try...

CASE WHEN TradeType <> 'VANILLA' THEN banksidePremium ELSE .... END AS [BANK PREMIUM]

---

Blog: www.adathedev.co.uk

Answer 2

CASE WHEN TradeType <>'VANILA' THEN ..... END FROM tb'

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 3

Try:

CASE WHEN tradeType <> 'VANILLA' THEN banksidePremium END AS [BANK PREMIUM]

Alternatively:

CASE tradeType WHEN 'VANILLA' THEN NULL ELSE banksidePremium END AS [BANK PREMIUM]

---

Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/

Answer 4

thx all :)

Answer 5

for some reason this always returns false:

  CASE when tradeType <> 'VANILLA' THEN banksidePremium  END AS [BANK PREMIUM],

Answer 6

encapsulate the else part also

case when tradetype<>'VANILLA' then banksidepremium else <add the else part here> end as [Bank Premium]

---

Thanks and regards, Rishabh , Microsoft Community Contributor