CREATE TABLE number_data_types (
numberic_column numeric(20,5),
	real_column real,
	double_column double precision);

INSERT INTO number_data_types VALUES 
(.7,.7,.7),
(5.98231,5.98231,5.98231),
(5.9823112345,5.9823112345,5.9823112345);

SELECT * FROM number_data_types;





-------------------------------------------------
SELECT numberic_column * 10000000 AS fixed,
real_column * 10000000 as floating FROM number_data_types
WHERE numberic_column = .7;