Format number results in TSQL

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 1

dint this work?

select cast( 25.000000 as decimal(25,2))

konstantinos.christodoulakis SSC-Addicted Points: 496 More actions · Answer 2

It returns 25.00 with "." separator.

I want to have comma separator (",")

Any help?

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 3

Probably there is a straight-forward way, but this is what i have come up with :

select replace(cast ( convert(decimal(25,2),25.00) as varchar) , '.' , ',') Comma_Value

konstantinos.christodoulakis SSC-Addicted Points: 496 More actions · Answer 4

SSC-Addicted

Points: 496

August 30, 2010 at 2:52 am

Thanks