removing dashes from SSN

[aglabrat]

In my table I use the SSN format. In my query I want the SSN without the dashes. Could someone help with this. I have thought about using Left, Mid, Right, string function but can't find proper usage of these in queries.

Any help would be appreciated.

 

[jzwp22]

You can use the Replace function as follows:

SELECT Replace([SSN],"-","") as SSNNoDashes
FROM tableanme

 

[Isskint]

You just need the Replace function.

 

[aglabrat]

I may not have explained it well. I do not want to chege the data in my table. I built the query to fill a report. The person wanting the report does not want the dashes in the report.

Thanks for the quick responses and any help you cann give on this

 

[pr2-eugin]

The suggestion provide does not change the data it will show 'AS' SSN with no dashes..

 

[aglabrat]

Thanks will try

 

[Graycom Consulting]

Try using the replace function in the query. Access has its quirks. Search youtube under my user name. I made a video specifically for this issue.

 

[pbaldy]

This is almost a 7 year old thread. I hope you're not just spamming our forum.

 

[vba_php]

i already reported it as a possibility paul

 

[pbaldy]

i already reported it as a possibility paul

Yes, I know. That's why I posted.

 

[vba_php]

Yes, I know. That's why I posted.

so does your title "wino moderator" mean that you are one? I guess I never caught on to that. did that report of mine go to u?

 

[pbaldy]

Just a joke dude. Reports go to all moderators.