Need help regarding comparing field values

[#1]

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.

Thanks in advance.

Regards,

Akshata

[swuehl]

Have a look at

Data Cleansing