In another thread someone suggested I use MINUS, but I was under the impression that only Oracle had the MINUS function, does SQL Server 2005 also have this option?(I know I can use NOT EXISTS but ...

note that, in SQL Server 2008 (IIRC) the varchar (max) is now huge and can avoid any need for TEXT columns.<BR><BR>Simply changing to that can solve a whole host of issues.