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.

Slavek

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
e-mail:skopalik@...
http://hlubocky.del.cz