Multiple database access problem

Hi ,

Im developing a web application which would make access to multiple distributive databases. The problem is....the database from all the third parties may have different standard.
For instance....a user wish to retrive a record from many databases, he input "Pentium 4" .....but some database may have different standard, they may have a record with name "P4" instead of "Pentium 4"....so my question is , how should i make it standard ?? thanks

I had a similar problem with Customer names. Some call it "Pittsburgh Plate Glass", some "PPG". To solve this problem I created a table I called Aliases. In this table I put 2 columns. The first column was the customer name I wanted to use as a standard, the second was the alias for the customers.

The entries for PPG would be:

Col1,Col2
PPG,Pittsburgh Plate Glass
PPG,PPG
PPG,Pittsburg Plate Glass

This works well if you don't have alot of alias to do, as its pretty much a manual entry kind of thing.