Re: format a numeric values with commas

From: Hari (anonymous_at_discussions.microsoft.com)
Date: 09/28/04 

Date: Mon, 27 Sep 2004 18:40:18 -0700

thanks Steve,
it's working fine for removing zeroes and formating it
with commas. i changed it with combining ur previous and
current answers.

rgds,
hari.

>-----Original Message-----
>See my answer to your other question about removing zeros.
>
>SK
>
>hari wrote:
>
>>hi Steve,
>> Thanks for that. it is working fine.
>> But for the whole numbers like 123456 it is not doing
so.
>> it is formatting to 1,234,567.00 (with two zeroes after
>> decimal). i want it to be formatted as 1,234,567
>>
>> how to format 1234567 to 1,234,567
>>
>>thanks,
>>hari.
>>
>>
>>
>>>-----Original Message-----
>>>declare @list_price numeric(20,6)
>>>set @list_price = 1221512.34
>>>
>>>select
>>> convert(varchar(100),cast(@list_price as money),1)
>>>
>>>Steve Kass
>>>Drew University
>>>
>>>hari wrote:
>>>
>>>
>>>
>>>>hi,
>>>> I have requirement.
>>>> I want to format a numeric value with commas. is
there
>>>>any function to use in transact-sql query to do this.
>>>>for example if the numeric value is 27519.37 then it
>>>>should be formatted as 27,519.37
>>>>if the numeric value is 1221512.34 then it should be
>>>>formatted as 1,221,512.34
>>>>
>>>>regards,
>>>>hari.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>.
>>>
>>>
>>>
>>.
>>
>>
>>
>>
>.
>

Relevant Pages