number with point of thousand

• sistemas_casinomnes

  SSChasing Mays

  Points: 659

  More actions

  January 29, 2013 at 9:02 am

  #288557

  I need to show a number with point of thousand and 2 decimal places.

  For exmaple the number 6058, I have to show as 6.058,00

  How can I do that?

  Thanks

• Mike01

  SSChampion

  Points: 11395

  More actions

  January 29, 2013 at 9:52 am

  #1582234

  You can do this with a simple cast function, but I would ask why. If this is for presentation, then the presentation layer should format it, not from the database. To show 2 decimals, you can cast it like this

  select CAST(6058 as decimal(10,2))

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/