# The "variant" data type is not supported

**URL:** <https://forum.inductiveautomation.com/t/the-variant-data-type-is-not-supported/32053>\
**Category:** Ignition\
**Created:** [February 7, 2020, 3:59pm UTC](https://forum.inductiveautomation.com/t/the-variant-data-type-is-not-supported/32053 "2020-02-07T15:59:11Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hazmat480](https://avatars.discourse-cdn.com/v4/letter/h/97f17d/32.png) [@Hazmat480](https://forum.inductiveautomation.com/u/Hazmat480)\
**Post date:** [February 7, 2020, 3:59pm UTC](https://forum.inductiveautomation.com/t/the-variant-data-type-is-not-supported/32053/1 "2020-02-07T15:59:11Z")

</div>

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.