All Forums Database
vinod_sugur 22 posts Joined 04/05
02 Jan 2006
Union query 2616 error

select 127 from customerunionselect 131 from customerThe above query generates the subject mentioned the qorkaround is typecast the value 127 to Integer. the reason for the error is the value 127 is considered as Byte and 131 as Integer and the query optimizer tries to convert 131 to Byte, so it gives the subject mentioned error.Is this the only solution?Thanks,

Dennis Calkins 12 posts Joined 07/04
02 Jan 2006

Make them the same type..sel cast(127 as Integer) from customerunionsel cast(131 as Integer) from customer;

You must sign in to leave a comment.