Sql checking null

I want to check for data, but ignore it if it's null or empty. Currently the query is as follows But I want to get company.

OfferTex t if listing. Offertext is an empty string, as well as if it's null. In this example, if listing. This is similar to the accepted answer, but it also has a fallback in case Company. OfferText is also null.

Use the LEN function to check for null or empty values. This will return false if the value is NULL, '', or ' '. Also, LEN ' ' returns 0. See for yourself run:. I know this is an old thread but I just saw one of the earlier posts above and it is not correct. If you are using LEN There is a space between the single quotes. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Collectives on Stack Overflow. Learn more. How do I check if a Sql server string is null or empty Ask Question. Asked 13 years, 1 month ago. Active 1 year, 3 months ago.

Viewed k times. Select Coalesce listing. OfferText, company. 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. Get certified by completing a course today! If you want to report an error, or if you want to make a suggestion, do not hesitate to send us an e-mail:.

Exercise: Select all records from the Customers where the PostalCode column is empty. Report Error. Your message has been sent to W3Schools. W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content.