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