The SQL below is used for taking a number and formatting it to a SSN.

 

select ssn,LEFT(ssn,3) + '-' + SUBSTRING(ssn,4,2) + '-' + RIGHT(ssn,4) from DbTools..Sheet1