>Fabio,
>
>Do not expect this behavior to be changed. I posted a bug report on this a couple of months ago and it is working as designed.

David,

Which bug? The one in this thread where I pointed out where a UNION does not cast the data type properly?

select CAST(NumField as I) AS MyField from MyCursor where .f.
UNION ALL
select NumField from MyCursor where some_filter
into cursor crsResults

MyField in the crsResults comes out a numeric and not integer. This is hopefully NOT by design and not working as I expect.