Force real to show trailing zeros

In SQL how can I force a datatype real to show trailing zeros?

You should not be using SQL to format your data. SQL is a data repository and not a reporting tool.
The only way to get leading zeros I know is to convert to character and add the zeros.

Thank you.