>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...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.