Enforce 2 decimal places after a column result in s query.

Summary:

The table column can have values like 2,3,56.78,34,8 etc. We need something on the query such that 2 must show up in query result as 2.00, 67 as 67.00,45.6 as 45.60 etc.

we need it to happen in SQL query.

Content (required):

There is a table column that can have number values like 2,3 ,400,45.78,34,28 ,4.00 etc. Is there a way in SQL to stipulate it to always have 2 places after decimal like 2 must show up in query result as 2.00, 67 as 67.00,45.6 as 45.60 etc.

This is a system table & hence no table level constraints are possible.

Any idea would be appreciated.

Thanks,

Aloka

Version (include the version you are using, if applicable):