>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?
>
> ...kt
something like

select 000000.00 as FstCol...
union ;
SELECT VAL( Col1) AS FstCol, VAL( Col2) AS SecCol ;
FROM TEST1 ;
INTO TEST2

Arnon