SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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'.
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