Author Skopalik Slavomir
Actualy, AVG is compute as sum(x) DIV count(x).
I think, that AVG should always return Double Precisin like
other SQL engines.
I was tested BDE, MS Jet, ORACLE 7.3 and all returns float.
Only one (IB6.5) returns AVG like FB.


ing. Slavomir Skopalik DEL a.s.
Olomoucka 355 Marianske udoli 783 75
Czech Republic
Tel: 585 353 548
Mobil: 602 795 874
Fax: 585 352 364