Formatting a Numeric value in 1000 Separater

Question

Post reply

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

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

Madhivanan-208264 SSCertifiable Points: 7516 More actions · Answer 1

SSCertifiable

Points: 7516

November 14, 2008 at 7:33 am

Sudarsan Srinivasan (11/14/2008)

Hi,

How do i format a numeric value in 1000 separated value.

eg. 10000.00 as 10,000.00

Where do you want to show formatted values?

If you use front end application, use format function there

Madhivanan

Failing to plan is Planning to fail

Sudarsan Srinivasan Ten Centuries Points: 1140 More actions · Answer 2

Ten Centuries

Points: 1140

November 14, 2008 at 7:41 am

I want that in the backend..

Madhivanan-208264 SSCertifiable Points: 7516 More actions · Answer 3

SSCertifiable

Points: 7516

November 14, 2008 at 7:45 am

Sudarsan Srinivasan (11/14/2008)

I want that in the backend..

That is not the correct answer to my question

Anyway



declare @val decimal(12,2)

set @val='10000.00'

select convert(varchar(15),cast(@val as money),1)

Madhivanan

Failing to plan is Planning to fail