I have a address in more than one column in a table.
SELECT FirstName, LastName, StreetAddress, City, Country, PostalCode
FROM Client
I am trying to concatenate address related columns into one filed using Comma (,) as a separator but if any of the column "eg. City" is null or empty, comma should not be there.
How to use ternary operator in TSQL like one has in c#? Or suggest me the best practice?
Thanks
See Question&Answers more detail:os