5 Replies Latest reply: Jul 3, 2013 8:14 AM by Greg Spall RSS

    sorting - like ORDER BY ISNULL(price1,price2) ASC

    julia

      Hi All,

       

      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

       

      thanks,