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

    Row value comparision of two columns

      Hi,

       

      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.....