SQLTeam.com | Weblogs | Forums

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.