I want to write a procedure to pass on the table name and the PK of that table to do that. if possible.

I am trying to get some dynamic error processing... where if error occurs on any procedure writing to any table then the error writes the whole table row data as...

is there a way that I can covert multi table data into single table with one xml column by just providing the table name?

like table1 (col1 int, col2 date);

table2(col3 varchar(10),...

Yes, I agree its not the perfect solution. So depending the degree of perfection, it may or may not be used.

Try SOUNDEX... split each word and find it both ways. I have used SONDEX but not in this exact manner. Let us know what worked.