Getting Rid Of Dashes

I am trying to get rid of dashes in SSN if entered by user.Putting the ssn in database and must not have dashes.Can I take dashes out of a string and if so HOW?Or can I make the field in the form so user can not use a dash?

View Replies


ADVERTISEMENT

Searching For String Without Dashes

I have a database with part numbers and information about the parts. Several of the part numbers have hyphens (dashes) in them. When the user searches for a part number, sometimes their part numbers may have spaces instead of dashes. Sometimes they have no dashes (just the alphanumeric portion of the part number.

For example, the database may have the part number: 'MP-1330'
The user might try to search for 'MP1330' or maybe even 'MP 1330'

I would rather not change the contents of the database (i.e. by removing all of the hyphens, and removing hyphens and spaces from the search string. Code:

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved