I need help formatting an SSN field in my VB6 application.
Currently, the SSN's stored in my database have dashes in them. I want to replace the dashes.
I also want to make sure the SSN's are always 9 characters long.
This is a sample of what some SSN's look like in my database:
What I want the SSN's to look like after the formatting:
How can I accomplish this?
Thanks in advance,