6 Replies Latest reply: Apr 26, 2012 10:16 PM by Janani Kumar RSS

    if the value is exists - how to check on row wise data

      I have data is coming from table

      KeyCode
      HS0001
      HS000H2000
      HS000H2000H2001
      HS000H2000H2002
      HS000H2000H2003
      HS000H2000H2998
      HS000H2000H2999
      HS000H3000
      MP0002
      MP000MPAA0
      MP000MPAA0MPAA1
      MP000MPAA0MPAA2
      MP000MPAA0MPAA3
      LS00A1
      LS00AA10001
      LS00AA1000A1001
      LS00AA1000A1002
      CNE003
      CNE00CNEA0
      CNE00CNEA0CNEA1

       

      I would like to see the data for reporting  - checking the first 5 character or 10 character if the value exists in the Code column - I have to update the missing rows for the code.

       

      Expecting   Results
      KeyCode
      HS0001
      HS000H20001
      HS000H2000H20011
      HS000H2000H20021
      HS000H2000H20031
      HS000H2000H29981
      HS000H2000H29991
      HS000H30001
      MP0002
      MP000MPAA02
      MP000MPAA0MPAA12
      MP000MPAA0MPAA22
      MP000MPAA0MPAA32
      LS00A1
      LS00AA10001
      LS00AA1000A10011
      LS00AA1000A10021
      CNE003
      CNE00CNEA03
      CNE00CNEA0CNEA13


      Advance thanks for your help.