number format to 2 decimals

Tech-Archive recommends: Fix windows errors by optimizing your registry

How can I format my data to 2 decimal numbers in sql ?

select numericColumn from table1

ex :-

numericColumn
---------------
10.22
20.00
30.45
12.02

regards
ypul


.

Relevant Pages

  • sql optimization
    ... Which newsgroup will help me in optimizing my query.. ... Regards ... Prev by Date: ...
    (microsoft.public.sqlserver.clients)
  • Re: number format to 2 decimals
    ... > ypul wrote: ... >> select numericColumn from table1 ... > What data type are you using in the table? ...
    (microsoft.public.sqlserver.clients)