SSN split

[Ted Dawson]

ASP/Access

One of my fields is the customer's social security number, all originally
entered as a 9-character string. How can I split and display that into 3-2-4
format?

 

[Aaron [SQL Server MVP]]

set rs = conn.execute("SELECT SSN From Table")
ssn = rs(0)
response.write left(ssn, 3) & "-" & mid(ssn, 4, 2) & "-" & right(ssn, 4)

 

[Stefan Berglund]

On Sat, 11 Sep 2004 14:43:36 -0500, "Ted Dawson"

ASP/Access

One of my fields is the customer's social security number, all originally
entered as a 9-character string. How can I split and display that into 3-2-4
format?

Not all SSNs are created equal! A perfectly valid substitute,
for instance, is the federal tax id # which can be a variety of
several formats including your favored 3-2-4 format.

 

[Ted Dawson]

Perfect! Thank you.

set rs = conn.execute("SELECT SSN From Table")
ssn = rs(0)
response.write left(ssn, 3) & "-" & mid(ssn, 4, 2) & "-" & right(ssn, 4)