I have an opening page where the user puts in their Social Security number. Lets say that they put it in as 123456789, no dashes. I then pass it to the next page, put it into a variable and use it in a query.
1. I need it to have the dashes, 123-45-6789. How can I insert the dashes? Is there a function that I can use to do this?
2. I would think the best way would be to have some type of check that looks to see if they have put it in with or without dashes. If they have, use what they put in, else put the dashes in. What function can I use to look for dashes in a string?
Thanks for any suggestions.
1. I need it to have the dashes, 123-45-6789. How can I insert the dashes? Is there a function that I can use to do this?
2. I would think the best way would be to have some type of check that looks to see if they have put it in with or without dashes. If they have, use what they put in, else put the dashes in. What function can I use to look for dashes in a string?
Thanks for any suggestions.