You, Me and Dynamics GP
MS SQL tips has published SQL code for Validating SSN against High Group list from Social Security Administration for SQL Server.
In Dynamics GP we do lot’s of work with Social Security Numbers. Many folks are feeling a little SSN pain right now with 1099’s and W-2’s. The code from MSSQLTips can be used to validate that a SSN is in a valid range. This is usually a first step/minimal verification process. It doesn’t ensure that the SSN is valid or that it is issued to the name provided with that SSN but it does help detect data entry errors or the simplest levels of fraud.
