Yak Posting Veteran
Posted - 07/03/2013 : 14:42:54
| I need update the AppID in table1 by comparing Table2. the data looks like below. Here the problem is AppNames in the both tables are not exactly same but technically they are same with partial match.
Null ||||CSO Services Operations
Null |||| CSP
Null ||||AAC Claims Systems
1 |||||Corporate Services Operations(CSO)
2 |||||Credit Servicing Portal(CSP)
3 |||||American Assuarance Company (AAC) Claims Systems
Please let me know how to get rid of this task.