Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

Use of assignment to $[ is deprecated at /usr/local/sbin/apxs line 86. , wwwxxx vim, mysql closing table and opening table, 800c5000, setgid operation not permitted, pciehp: acpi_pciehprm on IBM, WWWXXX.DBF, 078274121, info0a ip, should prodicers of software_based services be held liable or not liable for economic injuries

Links

XODOX
Impressum

#1: SSN format

Posted on 2008-04-13 21:19:52 by Pat_RI

I have a query where I need to have the SSN appears as 123456789 instead of
123-45-6789 can someone help me with this? The table has it as 123-45-6789.
I would like to do it without running an update query with the replace
function and would also like to avoid using left,mid,right if at all
possible.

Report this message

#2: Re: SSN format

Posted on 2008-04-13 21:28:22 by Rick Brandt

Pat_RI wrote:
> I have a query where I need to have the SSN appears as 123456789
> instead of 123-45-6789 can someone help me with this? The table has
> it as 123-45-6789. I would like to do it without running an update
> query with the replace function and would also like to avoid using
> left,mid,right if at all possible.

Use Replace() in the query...

SSNum: Replace(SSN, "-", "")

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Report this message