Null value handling

Question

Let's assume i have a query

SELECT val FROM tbl

I want to write query that will output "ValueIsNotNull" when val is not null and "ValueIsNull" when val is null. Is it possible to do this with one line. As of now i found only ISNULL(val,'ValueIsNull') AS val1. But if value is not null then original value is printed.

score 9 · Accepted Answer · 2012-07-17 13:53:00Z

9

select
    case
        when val is null then 'ValueIsNull'
        else 'ValueIsNotNull'
    end
    as NewVal
from tbl

edited Jul 17, 2012 at 13:53

answered Jul 17, 2012 at 13:50

user596075

Sign up to request clarification or add additional context in comments.

2 Comments

seeker Over a year ago

Thanks, that works. And one offtopic question. Is there any way in C# to write multiple line strings?

user596075 Over a year ago

Yes, use the @ in front of the string for multiline strings. That's a very random question.

Gordon Linoff · Accepted Answer · 2012-07-17 13:50:23Z

3

You want the case statement function:

select (case when val is NULL then 'ValueIsNull' else 'ValueIsNotNull' end)

answered Jul 17, 2012 at 13:50

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Comments

Paul Fleming · Accepted Answer · 2012-07-17 13:50:23Z

3

SELECT CASE WHEN val IS NULL THEN 'ValueIsNotNull' ELSE 'ValueIsNull' END

answered Jul 17, 2012 at 13:50

Paul Fleming

24.6k8 gold badges79 silver badges113 bronze badges

Collectives™ on Stack Overflow

Null value handling

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related