This discussion is archived
1 Reply Latest reply: Feb 2, 2013 7:31 AM by Jim Smith RSS

Number plan comparison logic

980086 Newbie
Currently Being Moderated
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..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points