How to select multiple columns and return the one which is not empty
Posted on 2012-04-09
I'm working on a SQL query for an application and there are 3 fields, first, last and company name. If the first and last name are empty then I want to return the company name and if the first and last name have data, I want to return that information. I was originally using the following statement:
SELECT c.ID, coalesce (c.LastName + ', ' + c.FirstName, c.Company) AS Name
FROM Customer as c
ORDER BY LastName
I then realized when I commit data to the database from my application which is written in C#, it's not saving a Null value to the database when a field is blank so coalesce does not work for my purpose. Is there a similar way to achieve the above query that works on empty strings?