Member Avatar for MarlaFC

Hello All,

I came across with the following case and I would like to share it with you to get your opinions about.

In vb.net I use data from tables (oracle db) and i want to check two columns. Both columns have name of customers. All I want is to check if there are similar names. For example name "philip cole" could be the same with "p cole" or "cole philip" or "cole p". I'm trying to find an algorithmic logic to search between these two columns and find possible duplicates.

More specifid, i want to search if 4 or more consecutive characters appear in the other column.

Thank you for your time
MarlaFC

  • 2 Contributors
  • 2 Replies
  • 95 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by MarlaFC
Member Avatar for Jx_Man

Use "Like" on your query statement.

Member Avatar for MarlaFC

Thank you Jx_Man for the sql help but since i have a loop statement to check every consecutive 4 letters, i would prefer a .net logic. I think i'll try to pass the columns into arrays and search inside them.

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.