Member Avatar for sjgriffiths

Hello

I want to update a table with ID from another table, where the companyname field within the tables match as below

ABC LIMITED
Would Match
AST BIRCH CONT LIMITED

I basically want to take the 1st letter of each word

Can someone help me

  • 2 Contributors
  • 1 Reply
  • 138 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by haggis-man
Member Avatar for haggis-man

I would suggest you create an entirely new table with only two fields ... full name and acceptable abbreviation for each customer.

Any automated attempt to join tables as you describe will, I surmise, only run into problems since "ABC LIMITED" can be derived from many many other names.

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.