asked on

CASE WHEN is null - SQL Server

select 
    case col when null then 'No' else 'Yes' end 
 from table

Open in new window

The yes comes through but the No part comes back as null.

How to fix? Using SQL Server I've tried numerous variations with no success.

SOLUTION

DOSLover

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

patriotpacer

ASKER

This gives same results

select case when col IS null then 'No' when col IS not null then 'Yes' end from table

SOLUTION

Qlemo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

DOSLover

Does the column show 'NULL' when listed? or the filed contains ''? Can you please list some rows from the table, listing few of both?

patriotpacer

ASKER

My apologies. Won't be able to test until Monday.

ASKER CERTIFIED SOLUTION

PortletPaul

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

vivekkumarSharma

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

patriotpacer

ASKER

I appreciate all the help. I did try every solution but all gave me the same result - which the Yes values come through but No values always came null.

I did a workaround with an "isnull" wrapped around me case statement to get it to work.

Given the pattern and knowledge posted here, I'm assuming this is still an issue on my side.

But I do believe the solutions posted will work in most cases, so I'm going to close out this question.

I really appreciate all the help.