Thanks!

>Use CAST() function
>
>>
>>What determines the length of a calculated numeric field in SQL? In the following example I was expecting no decimal places, since the calculated field in the first record was 0. However, lo and behold, the structure is N(10, 4). Where did the SQL get that?
>>
>>I used this test because in the real environment I was getting either '0' or '*' in all the records and I was trying to figure out a way to 'force' a N(10, 5).
>>
>>

>>SQL Code
>>SELECT *, num1/num2 num3 ;
>>FROM test ;
>>INTO CURSOR curtest
>>
>>Table Test structure
>>Num1  3, 0
>>Num2  3, 0
>>
>>CurTest Structure
>>Num1  3, 0
>>Num2  3, 0
>>Num3  10, 4
>>
>>Data in Test
>>Num1    Num2
>>0            4
>>500        49
>>500        3
>>
>>Data in curTest
>>Num1    Num2   Num3
>>0            4             0.0000
>>500        49           1.0020
>>500        3          166.6667
>>

>>
>>Thanks,
>>
>>Yossi