I have 2 tables : In table 1 we insert data from the db normally , the second we use a text file and bulk insert.
I have one common string (used for join in the two tables)
in case they both shows a string with special character like Maintenance, Repair & Overhead with the same len (41)
when I try to join them , they are not joined anf returns no results
In case it is a word with no special characters such as Agile methodologies works fine ...
\Please help me in this