Results 1 to 1 of 1

Thread: how do i select

  1. #1
    Join Date
    Oct 2006
    Posts
    14

    Unanswered: how do i select

    Helllow there,

    I have a table called tels like the one below:

    Tel_Number Extension TelNo1 TelNo2 TelNo3 TelNo4

    945/10/250/3 10/250/3 945

    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.

    I hope the question is clear enough. Thanks
    Last edited by Sany84; 11-09-06 at 10:55.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •