Home Forums SQL Server 2005 Development T-sql Select statement RE: T-sql Select statement

  • 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)