I broke the telephone number down into TelNo1 and Extension usind substring and charindex. The problem im having is to use the extension to produce TeNo2 up to TelNo4.
This is the result i want:
Tel_Number Extension TelNo1 TelNo2 TelNo3 TelNo4
945/10/250/3 10/250/3 945 9410 250 93
What i want is to use the extension and TelNo1 to formulate other Telephone numbers. For example, for TelNo2 since the first part of the extension has 2 characters, i want to replace the last 2 characters of TelNo1 with the first 2 characters of the Extension. I use the '/' as the separator in the Extension.