Joel
4Penny.net
Points: 10550

4/17/2012 10:06:30 AM

SQL - Function to format a Social Security Number

More articles like this can be found on our SQL Data Access menu.   

Dynamics GP stores phone number and Social Security Numbers without the dashes, this function will format an SSN for you

Use it like this:

select
        lastname,
        dbo.f_FP_SSN(socscnum) as SSN
    from dbo.upr00100
4Penny.net
Version: Unknown or N/A
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3