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)

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Ted Dawson" <sc********@hotmail.com> wrote in message
news:#Y**************@TK2MSFTNGP09.phx.gbl...

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?

[Stefan Berglund]

On Sat, 11 Sep 2004 14:43:36 -0500, "Ted Dawson"
<sc********@hotmail.com> wrote:
in <#Y**************@TK2MSFTNGP09.phx.gbl>

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.

---
Stefan Berglund

[Ted Dawson]

Perfect! Thank you.

"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:uq**************@TK2MSFTNGP15.phx.gbl...

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

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Ted Dawson" <sc********@hotmail.com> wrote in message
news:#Y**************@TK2MSFTNGP09.phx.gbl...

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?