Check if null sql server

Improve this answer. Martin Ba Martin Ba I couldn't decide if I should upvote your answer or unclefofa's, since he seems to have answered first, but his answer has been edited after you answered.

I ended upvoting both. I am sadfused. As long as company. Shouldn't we use trim to make sure everything goes as planned — irfandar. Otherwise a string with all spaces is not empty. Show 1 more comment.

OfferText,'' , Company. OfferText, '' This is similar to the accepted answer, but it also has a fallback in case Company. Joel Coehoorn Joel Coehoorn k gold badges silver badges bronze badges.

This got upvoted today, so it's indexed somewhere. I now know a better way to do this than the original answer. OfferText is null or listing. Patrick Harrington Patrick Harrington Anax 8, 5 5 gold badges 30 30 silver badges 66 66 bronze badges.

Adriano Carneiro Code Trawler Code Trawler 2 2 silver badges 7 7 bronze badges. Zach Johnson Zach Johnson 5 5 silver badges 12 12 bronze badges. When you say " Mansoor 12 12 bronze badges. Milan Milan 2, 1 1 gold badge 31 31 silver badges 43 43 bronze badges.

Romain Durand Romain Durand 1 1 gold badge 5 5 silver badges 20 20 bronze badges. Select Coalesce NullIf listing. OfferText, '' , NullIf company. Muhammad Sharjeel Ahsan Muhammad Sharjeel Ahsan 3 3 gold badges 13 13 silver badges 26 26 bronze badges.

OfferText is null. However, the 2nd NULLIF call here serves no purpose, as if that value an empty string you're just going to coalesce back to an empty string anyway. OfferText, '' , company. Here's a solution, but I don't know if it's the best Select Coalesce Case When Len listing. OfferText, 'company. Bo Persson Anoop Verma Anoop Verma 1, 14 14 silver badges 19 19 bronze badges.

Rndm 6, 7 7 gold badges 36 36 silver badges 58 58 bronze badges. Code Crawler Code Crawler 43 5 5 bronze badges. This would be the first port of call but if you are doing things like concatenating from multiple columns in a table for example, then this would exclude the row rather than just display a blank for that column — Coops. Paul Roub Hicham Hicham 31 1 1 bronze badge. Vedran Vedran 9, 4 4 gold badges 45 45 silver badges 57 57 bronze badges.

This caters for spaces as well. ChrisM 6 6 silver badges 16 16 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Krishh Krishh 3, 4 4 gold badges 40 40 silver badges 52 52 bronze badges.

So, why is it wrong? Filter supposed to be a function? Your where condition seems to be fine When I am manually passing zipcode as null, it is not returning any result. But when I am replacing the entire statement to [Portal]. I did not know why it happening like this. When I am breaking up the statements and executing seperatly with the values defined, they work great. Add a comment. Active Oldest Votes.

Try: if zipCode is null begin [Portal]. Improve this answer. Isnull syntax is built in for this kind of thing. Travis Travis 4 4 bronze badges. You don't have a conditional operation in your where clause. Kate Orlova 2, 5 5 gold badges 10 10 silver badges 28 28 bronze badges.

Raj Kumar Raj Kumar 31 6 6 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.