I have 2 tables each having same column but data in one column differs from the other.
Ex tableA has col1 varchar(255)
data is
/aaa/bbb/ccc/mytest.xml
/bbb/nnn/mmm/mytest1.xml
ooo/ppp/bbb/mytest2.xml
TableB has col1 varchar(255)
data is
/aaa/bbb/ccc/mytest89.xml
/bbb/nnn/mmm/mytest1.xml
ooo/ppp/bbb/mytest2.xml
Now record 1 in both tables differ in the xml filename, 1st case its 'mytest.xml' and 2nd table its 'mytest89.xml'. Is it possibel using tsql function to extract all records where only the filename differs. Any help on this will be greatly appreciated. TIA