T-sql compare null and string

Community Bot 1. Martin Smith Martin Smith This is great, I tested it out and it seems to behave exactly as I need it to. Thanks very much. Drat it you beat me to it! Though I have to confess you taught me this method. It's so beautiful. Martin, are you using this approach to compare the tables that are too large for Data Compare?

Hope this help. QMaster QMaster 4 4 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. Consider a table users where the gender column is nullable. Second, you can convert the NULL values into a real value during query time or only when sorting. For example,. Say you have two tables: table1 and table2 with a column that can have NULL values.

If you were to join these two tables on that value, you have to be aware of the fact that NULL is not equal to NULL , and therefore, it would appear as though you are missing rows from the resulting joined table.

No spam, ever! Unsubscribe any time. What's the best performing solution? Add a comment. Active Oldest Votes. 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.