>Fabio,
>
>Can you post code that reporo the bug?
create cursor MyCursor (F1 N(6,0))
insert into MyCursor values (100)
*!* returns a numeric column instead of Integer
select cast(F1 as I) where .f. FROM MyCursor ;
union ALL ;
select F1 from MyCursor ;
into cursor crsResults
DISPLAY STRUCTURE
*!* following works as expected
select cast(F1 as I) where .f. FROM MyCursor INTO CURSOR crsResults2
DISPLAY STRUCTURE
Mark McCasland
Midlothian, TX USA