Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

WWWXXXAPC, WWWXXX .CMD, Wwwwxxx reemine, WWWXXX.VCBA, WWWXXX.VCBA, TheboL.wwwxxxxx, WWWXXXAPC , wwwxxn.xsss, wwwxxxapc, WWWXXX.VCBA

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