Case When ISNULL

Question

Hi,

I have the following Case statement, but my logic doesn't seem to work, any idea why this is please?

case when method = 'TP' and second_method ISNULL then 'New' end as Method_Type

This is my error message:
An expression of non-boolean type specified in a context where a condition is expected, near 'ISNULL'.

Answer 1

Provide a space in between "IS NULL"

try:

case when method = 'TP' and second_method IS NULL then 'New' end as Method_Type

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav