Member Avatar for iann

Hi Guys

It may be friday, but I am having a real brain fade with this one.
I have one table which contains several columns (see below) I need to match names in the tables. The first name is in column childname1 which contains the full name, the column I need to match to is in "firstname" and "familyname" columns respectively.

I need a display the groupid beside the matching childname1 column. Now I can think of concatenating the first and family name columns to make it easier I can also think of doing it in excel, but I am looking for a count match on the first 3 letters of the firstname to the childname1 first name.
any ideas, have looked at pathindex and charindex to work it.!
groupid
093911982| NULL| Margaret| Johnston| Miss Grace Johnston|
037281982| NULL| Louise|Kelly|Ms Brianna Kelly|
083753534|NULL|Grace|Johnstone|NULL|

cheers

  • 2 Contributors
  • 1 Reply
  • 65 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by urtrivedi
Member Avatar for urtrivedi

You may use substr function

Edited by urtrivedi because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.