When two expressions of the same data type but different lengths are compared by using UNION, EXCEPT, or INTERSECT, the resulting length is the maximum length of the two expressions.

• 使用UNION、EXCEPT或INTERSECT对数据类型相同但长度不同的两个表达式进行比较时,得到的长度为两个表达式中较大的长度。