How to format a decimal data type (SQL Server 2000) when displayed (in datagrid)
Posted on 2006-04-21
I have field that is decimal datatype (10,4). Currently, when a number such as 3.25 is entered, it shows up as 3.2500 (after it is saved to the db and retrieved again). And whole numbers, such as 44, show up as 44.0000. I would like to have have the zeros show up at the right of the numbers. Is there a format that will do this? So, for 44, I really do want just 44 to show up. And for 3.25, I really want just 3.25 to show up.