This content has been marked as final. Show 5 replies
I am trying to find out solution on below senario.
there are two properties, price1 and price2.
Some records have both properties and some records have only price2.
When we sort, if price1 exists, use price1, if price1 does not exist, use price2.
could be like ORDER BY ISNULL(price1,price2) ASC on sql query