Decimal Places

Question

Why does the number of decimal places in the outputs of AVG and SQRT differ? Can we set that? Thank you so much!

Answer 1

CAST [ your field] AS [data type] [format];
for example:
CAST (filename AS decimal (10,2)) for two decimal places.