Forum Replies Created

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

  • RE: Sql Query to find invalid SSN Numbers

    Jeff Moden - Tuesday, March 12, 2019 11:11 AM

    Sean Lange - Tuesday, March 12, 2019 8:33 AM

    March 12, 2019 at 11:36 am

    #2024252

  • RE: Sql Query to find invalid SSN Numbers

    I've been using the following and it's proved successful.

    WHERE LEN(SSN) <> 9
     OR LEFT(SSN,1) IN ('8')
     OR LEFT(SSN,2) IN ('74','78','79')
     OR LEFT(SSN,3) IN ('666','734','735','736','737','738','739','773','774','775','776','777','778','779')
     OR LEFT(SSN,3) = '000'
     OR...

    March 12, 2019 at 8:02 am

    #2024220

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