>I have a table with character values and I want
>to extract them as integers.
>
>I'm basically doing something like
>SELECT VAL( Col1) AS FstCol, VAL( Col2) AS SecCol ;
> FROM TEST1 ;
> INTO TEST2
>
>Is there a way of controling the data type of
>a column with SQL SELECTs?

You might be better off doing CREATE CURSOR first and then scan table to fill in the values, you'll have more control...