How can I implement IsNull and Isempty together in sql server query

Question

here I wanted to check if coming value is empty string or null then use value from Db column.Like I did for is null case. How can i check for empty string in this line of code.Please suggest

II.[NAME] = isNull(IIMODEL.[Name], II.[NAME]),

Can I use Case for this?

Ricky
– Ricky

2020-07-18 07:09:47 +00:00
Commented Jul 18, 2020 at 7:09 — Ricky
– Ricky, Commented Jul 18, 2020 at 7:09
What is the "incoming" value?

Gordon Linoff
– Gordon Linoff

2020-07-18 12:11:41 +00:00
Commented Jul 18, 2020 at 12:11 — Gordon Linoff
– Gordon Linoff, Commented Jul 18, 2020 at 12:11

Alexander Petrov · Accepted Answer · 2020-07-18 07:13:10Z

2

II.[NAME] = ISNULL(NULLIF(TRIM(IIMODEL.[NAME]), ''), II.[NAME])

answered Jul 18, 2020 at 7:13

Alexander Petrov

14.4k2 gold badges23 silver badges56 bronze badges

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

1 Comment

Ricky Over a year ago

this works , I also tried using Case that also works,Like this II.[NAME]=CASE WHEN IIMODEL.[Name] = null THEN II.[NAME] WHEN IIMODEL.[Name] = '' THEN II.[NAME] ELSE IIMODEL.[Name] END

Gordon Linoff · Accepted Answer · 2020-07-18 12:12:35Z

1

Why not just use explicit comparisons?

(II.[NAME] = IIMODEL.[Name] OR IIMODEL.[Name] IS NULL OR IIMODEL.[Name] = '')

I think the logic is much simpler to follow.

answered Jul 18, 2020 at 12:12

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Comments

pkr · Accepted Answer · 2020-07-18 12:17:13Z

1

case when isnull([column], '') <> '' then [column] else [other] end

answered Jul 18, 2020 at 12:17

pkr

1,8015 gold badges28 silver badges45 bronze badges

Collectives™ on Stack Overflow

How can I implement IsNull and Isempty together in sql server query

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related