Thanks a lot vinu512, for understanding my situation.

among all options you provided along with some I looked upon, I think adding new "ID" must be a good idea.The names not being unique as we used the same name for the used product and the new one indicating it on other columns .

so, going to first (but difficult kind of option Think), how shall I add the "ID" to this table which is around 53k big.

>><<I saw something called "lookup" and "fuzzy*lookup" these as far as I know are some statistical tools to compare the similarity and provides the confidence interval as well as the level of similarity.

would it be good idea to use it, I wanted to use it seems difficult. would it do what I am looking for to do?

my organization most of the time changes its sources of products, and different programmer are used to get those products to the database, there are same products from different supplier with same name but we try to display the cheapest one. The only way we use to differentiate the products is its kid.

Another problem is that it is not documented, most of the time have to go and see all the consequences of the changes I make.