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. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.
The cookie is used to store the user consent for the cookies in the category "Other. The cookie is used to store the user consent for the cookies in the category "Performance". It does not store any personal data. Functional Functional. Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features. Performance Performance. Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics Analytics. Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement Advertisement. Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads. Others Others. Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
Did you know? ETL by more than 30x. 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. 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. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta.
New post summary designs on greatest hits now, everywhere else eventually. Linked 6. Related Hot Network Questions.
0コメント