I want to match value by comparing 2 tables. Table 1 has got name,employee number column and Table 2 has only name column.

Table2 name column is matching with Table 1 name column.For example Table 1 value is "Brian Sammy Mathewson" and Table 2 value is "Sammy Matheson".So the value is matching by almost more then 50%.

I want to fetch those records where matching is more then 50%.Also the result should provide employee number alongwith the matching name.

I tried my best but nothing is working.

Thanks