0 Replies Latest reply: Apr 4, 2017 5:19 AM by sagar rahul RSS

    same names appearance

    sagar rahul

      hiiiiiiii ,

       

      having certain problem

      below is my table where there first name and last name is in one column only .

       

      custname
      sagar rahul
      rahul sagar
      r sagar
      s rahul

       

      so we want to check by taking first name at a time or taking last name at time what things are coming as output

       

      eg :

       

      lets us take sagar so we want to check how many time is coming in the custname column .

       

      so it should give me , all below which are having sagar will appeared

       

      result
      sagarrahul
      rahulsagar
      rsagar

       

      so after we take rahul  , all below which are having rahul will appeared

       

      sagarrahul
      rahulsagar
      srahul

       

       

      so need help .