SQL Data Types

What is the difference between a FLOAT and a REAL?   Last week, It was ten cents ($0.10) on $2.3 million dollar budget account.

Both FLOAT and REAL are approximate number data types.  FLOAT storage size is 8 bytes.  REAL storage size is 4 bytes.

I used REAL as a return type in a stored procedure.  The difference in precision cause the two reports not to match.

Looking Back

I should not have used either of these approximate number data types.   I think DECIMAL(18,2) would have been a better choice.