...., but the UNION select technique "fails", for example, when F1 is numeric - N(x,0) - and you want to cast as integer. By fails, I mean the resulting cursor comes back with a numeric field instead of integer. ....


This happen with a Currency and Double, also.
Simple, another bug, because on a UNION the first SELECT typing the result fields,
and the others union's SELECT have to perform a implicit conversion or fire a conversion
error.