7 Replies Latest reply: Oct 18, 2013 1:14 AM by Anju Gopinath RSS

    split and compare fields

      Hi,


      In a table,I have two fields A and B. I have to retrieve those rows where A<>B. The problem isA could be '12|14|15' and B could be '12|15|14'. So, they are actually same , only that the order of numbers is different. How do I retrieve rows where the fields are really not equal ,like'30|31|14' and '31|30|15', or '22|23' and '22' ?

       

      Thanks,

      Anju