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.OfferTex
t if listing.Offertext
is an empty string, as well as if it’s null.
What’s the best performing solution?