The "variant" data type is not supported

I wrote a sql query that joins two tables based on a substring. The query works fine in MS SQL, but when I try to run it in the Database Query Browser in Ignition 7.9.10 it gives me an error: the “variant” data type is not supported.