[AccessD] OT: Sum in MySQL

Hi all
I recall we have some MySQL gurus around ...

If you have a field of datatype Integer (Long in Access) and wish to sum this from a large amount of records, how would you do in MySQL?

In Access you would do something like:

  SELECT SUM(CDbl([FieldInteger])) FROM tblTable ...;

and the result would be a - potentially very large - Double.
What to use for CDbl() in MySQL?

/gustav