去除空格怪问题

select a.InvChfile,b.InvEnFile from InventoryexportFile a
left outer join InventoryAllFile b
on ltrim(rtrim(replace(replace(replace(replace(a.InvChfile,' ',''),char(9),''),char(10),''),char(13),'')))
like
ltrim(rtrim(replace(replace(replace(replace(b.InvChfile,' ',''),char(9),''),char(10),''),char(13),'')))
collate Chinese_PRC_CI_AS
B的这列的内容和A比就是多了一个空格，但是去空格也除不掉，高手解释下呀。