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

Use "Like" on your query statement.

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.