You're the best! IT WORKS!! I appreciate for your positive attitude and resolving this weird requirement from our client. Thanks a ton.

100% I agree with you Sean but this the requirement from our client side. The logic is weird and it is going to be more discrepancy at their end. These...

Yes.. inserting manually from their end - directly into table through statements

yes.. they are inserting themselves..

Inserting data into table both ways, through application and running insert statements as well.

Application : A process is running in client FTP this process picking data and inserting into table...

Thanks again.

Yes It is dynamic value and the ID will change during insert according to above conditions.

There are lots of end users who were inserting data into this table...

Thanks Sean for your reply. We know the requirement is quite odd because if there is any spelling mistake or abbreviations is used in the company name it wont match...