Hi All, Need your help in following issue. I have 2 fields called Bank Name 1 and Bank Name 2 Both are coming from different sources having sbank name in fields ,but values inserted is not proper format followed .
e.g
Bank Name 1 Bank Name 2
HDFC Bank HDFC Bank LTD
SBI State bank of india
So in above cases if i compare both fields then we must get value "YES" as both are same banks. But if I used "IF"
condition it will give only "NO " AS OUTPUT.
Please suggest me solution for this. Whether is it feasible to do.
