This is more like a logical issue than a technology related issue. Please feel free to move it, if required.
I am developing a registration process (Web App). An independent user or a company can register. In case of company is trying to register we ask few general information like company name, phone number, website address and things like this. Now my client has list of hundreds of thousands of companies that she wants to upload into the database. So when some company tries to register and if we have that company into our list then use that record instead of creating a new one. So what I need to do is I have to search first into list of companies into database and this where I need help.
During registration we ask company name, phone number, website address, fax number and information like this that I can use for search.
Case 1 : Using company name for search
- Javaranch can be spelled as Javaranch, javaranch, Java Ranch, JavaRanch Inc.
Case 2 : Using phone number for search
- User can enter XXX-XXX-XXXX or XXXXXXXXXX or XXX(space)XXX(space)XXXX