Renior,

You have to create a cursor beforehand and union it:

create cursor junk ( company c(..), characterfield c(10), integerfield i )

select junk.* ;
   from junk ;
   into ... ;
union ;
SELECT Company, SPACE(10) AS CharacterField, ;
   IntegerTypeField AS IntegerField ;
   FROM BlahBlahTable

>How do I create in SQL an Integer type field. For example:
>
>

>
>SELECT Company, SPACE(10) AS CharacterField, IntegerTypeField AS IntegerField FROM BlahBlahTable
>
>