1 Reply Latest reply: Feb 2, 2013 9:31 AM by Jim Smith RSS

    Number plan comparison logic

    980086
      Hi,

      I have a table containing -

      NAME CODE
      ---------- --------
      uk     93
      uk- Mobile - AT     9370
      uk- Mobile - AWCC     9372
      uk- Mobile - Etisalat     9375
      uk- Mobile - MTN     9377
      uk- Mobile - Roshan     9378
      uk- Mobile - Roshan     9379
      uk- Mobile - MTN 93809

      I need to make this in the following format & load that in another table---

      FROM TO
      -------- -------
      93 - 9369F
      9370 - 9370F
      9371 - 9371F
      9372 - 9372F
      9373 - 9374F
      9375 - 9375F
      9376 - 9376F
      9377 - 9379F
      9380 - 93808F
      93809 - 93809F
      93810 - 93F

      Please can Anyone help me out in this logic.....
      please..