Microsoft OLE DB Provider for SQL Server error '80040e14'The data types text and varchar are incompatible in the equal to operator.ERROR ON, line 17 LINE 17:mySQL ...

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 ...