9 Replies Latest reply: Jan 28, 2013 7:12 AM by Vishwaranjan Kumar RSS

    Comparing two coloums

    Jyothish KC


      i want to compare two columns in a staright table and give an output as "YES" if both the strings in the column are matched and "NO" if not matched.

      when iam using if(col1=col2,'yes','no') col1's all data is compared with 1st element of col2 and again all data of col1 is compared with col2 data.How can i avoid this???