You just need to replace the .noc out on the join. ie..
on t1.cola = replace(t2.cola,'.noc','')
can you use my SYntax what you mean?
select snetworkname from WhatsUp.dbo.NetworkInterface right outer join WhatsUp.dbo.device on WhatsUp.dbo.NetworkInterface.nNetworkInterfaceID = whatsup.dbo.device.nDefaultNetworkInterfaceID
where sNetworkName NOT IN (select item_keya as snetwork from dbo.item where item_keya is not null and item_keya <> '')
Because i want the 2 tables they must be compare together and only give me values there not in table item_keya...
Only the table snetworkname have in the value '.noc' so i get an result that says that every device not in my system is.. But is not true because '.noc' is the problem so i want that snetworkname disable the '.noc' and still have the value..