1 Replies - 2337 Views - Last Post: 30 August 2012 - 08:55 PM Rate Topic: -----

#1 shujatali  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 14-August 12

Compare string value with another string tabel value

Posted 14 August 2012 - 06:39 AM

Please help me

i need to compare two different table String and get finally one String

Like

Table A

Zeeshan Ali DR.(GYNAE)
Imran Abbas DR.(PED)
**Irfan Ali Dr

Table B
DR. Zeeshan Ali
DR. Imran Abbas
DR. Irfan Ali

i have to compare Table B String like "Zeeshan Ali" with Table A
and finally get Zeeshan Ali

Is This A Good Question/Topic? 0
  • +

Replies To: Compare string value with another string tabel value

#2 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: Compare string value with another string tabel value

Posted 30 August 2012 - 08:55 PM

This is doable. look into instr and mid.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1