Post reply

T-sql Select statement

  • October 6, 2010 at 7:59 am

    #241229

    i need to write a select statement that will show that there are duplicates. the first 4 are duplicates. so are the last 4. The Select statement must show only 2 results since there 2 duplicates

    +27828214883

    0828214883

    27828214883

    828214883

    +27834793687

    0834793687

    27834793687

    834793687

  • October 6, 2010 at 8:04 am

    #1232562

    cmoloto-996602 (10/6/2010)

    i need to write a select statement that will sure that there are duplicates. the first 4 are duplicates. so are the last 4.

    +27828214883

    0828214883

    27828214883

    828214883

    +27834793687

    0834793687

    27834793687

    834793687

    South African cellphone numbers... interesting...

    I would be tempted to look at the last 9 characters, like this:

    SELECT '+27(0)' + RIGHT(cellNumber, 9)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply