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