3 Replies Latest reply: Feb 1, 2015 12:55 AM by Robert Mika RSS

    Row value comparision of two columns



      I have two columns in the same table customer and currency as show below


      customer, curreny

      A           , -

      B           ,1$

      C           ,1r

      1            ,1r

      2            ,1$

      3           ,1r

      -           ,1$


      I need to replace all null and numeric values in customer based on currency


      example if customer=1 and currency=1$ or null i need to show a special instead of number or null in customer class


      can anyone suggest how to achieve this.


      Thanks in advance.....