Re: format a numeric values with commas
From: Steve Kass (skass_at_drew.edu)
Date: 09/26/04
- Next message: Steve Kass: "Re: how to suppress zeroes after decimal and whole no. should remain same"
- Previous message: Steve Kass: "Re: how to suppress zeroes after decimal point at the end in a value"
- In reply to: hari: "format a numeric values with commas"
- Next in thread: Hari: "Re: format a numeric values with commas"
- Reply: Hari: "Re: format a numeric values with commas"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 26 Sep 2004 00:58:56 -0400
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.
>>>
>>>
>>>
>>>
>>>
>>>
>>.
>>
>>
>>
>.
>
>
>
>
- Next message: Steve Kass: "Re: how to suppress zeroes after decimal and whole no. should remain same"
- Previous message: Steve Kass: "Re: how to suppress zeroes after decimal point at the end in a value"
- In reply to: hari: "format a numeric values with commas"
- Next in thread: Hari: "Re: format a numeric values with commas"
- Reply: Hari: "Re: format a numeric values with commas"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
