calculated values in sql: extending the decimal

Posted in 1997

Nelson Fredsell — Wed, 17 Dec 1997 13:43:03 GMT — source: Informix-list mailing list archive (1991-1998)

I'm dividing one number into another. Both numbers have 4 decimals, but the caluculated value has only 2 decimals. I would like the calculated value to also have 4 decimal places. How do I do this? select (table_a.col_a + table_a.col_b) / table_b.col_a pct from table_a, table_b where table_a.col_c = table_b.col_c thanks for the advice. -Nelson Nelson Fredsell Cornerstone Capital Atlanta, GA nfredsel@cornercap.com