SQLTeam.com | Weblogs | Forums

Force real to show trailing zeros


#1

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


#2

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.


#3

Thank you.