>does the T-SQL statement:
> select convert( float, int1 / int2 ) as myFloat
> into tempTable From ......
>
>have an equivalent in FoxPro ?
>I tried this:
> select int1/int2 as myFloat ;
> from ... ;
> into table tempTable
>
>the problem with this is that tempTable is created using the structure from the very first record of the resulting query. If the very FIRST records has int1 = 0, then the resulting data type of myFloat in tempTable is N(1,0) !!!!
>
>For all subsequent data, the myFloat value truncates the results to fit N(1,0) data type !
>
>help !
>
>my queries need to be dynamic (based on user-selections, complicated with the fact that each client has different data, but I would like to keep a common code base), so I cannot anticipate the structure of the tempTable before the query is run.

SQL determines the field type by the first value it sees. To make sure you've got what you want try adding something like 00000000.0000 to each value:

SELECT Int1 + 00000000.0000 AS MyNewValue, ...