How do I check if a Sql server string is null or empty

by

I want to check for data, but ignore it if it’s null or empty. Currently the query is as follows…

Select              
Coalesce(listing.OfferText, company.OfferText, '') As Offer_Text,         
from tbl_directorylisting listing  
 Inner Join tbl_companymaster company            
  On listing.company_id= company.company_id

But I want to get company.OfferText if listing.Offertext is an empty string, as well as if it’s null.

What’s the best performing solution?

19 Answers
19

Leave a Comment