26> CREATE TABLE variant2
27> (a sql_variant, b sql_variant )
28> GO
1> INSERT INTO variant2
2> VALUES (CAST (111 as int), CAST(222 as money ))
3> GO
(1 rows affected)
1> INSERT INTO variant2
2> VALUES (CAST (333 as int), CAST(444 as char(3) ))
3> GO
(1 rows affected)
1>
2> SELECT *
3> FROM variant2
4> WHERE a > b
5>
6> GO
a
b
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-
333
444
(1 rows affected)
1>
2> SELECT *
3> FROM variant2
4> WHERE a < b
5> GO
a
b
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-
111
222
(1 rows affected)
1>
2> drop table variant2;
3> GO
1>