Cast to double (1 reply)

The following returns a syntax error.

select cast(0 as double);

I need to work with scientific numbers, so conversion to a fixed-point decimal won't do.