Re: format a numeric values with commas

From: Steve Kass (skass_at_drew.edu)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 09:54:01 -0400

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

  • Re: Error in Date field format and calculation
    ... in the DTPicker with the days value in the 'hari' field.For example ... 'Start date' with the days value in the 'peruntukan' field.For example ... The format of the date in the database field is completely meaningless and all that code is doing is giving VB a chance to mess it up. ... Private Sub Form_Load ...
    (microsoft.public.vb.database)
  • Re: US and Indian Date conflict
    ... Date format this cell as desired. ... "Hari" wrote in message ... | those records I have to interchange the month and date value. ... | Is there a way to do this using formula or macro (what would be the logic ...
    (microsoft.public.excel.programming)
  • Re: Changing Default Date format in excel
    ... Since changing the short date style doesn't work, you could format the ... Hari wrote: ... Debra Dalgleish ...
    (microsoft.public.excel.misc)
  • Re: FORMAT
    ... Hari ... SQL Server MVP ... I have a query that goes like: ... I know there is a FORMAT function in access, ...
    (microsoft.public.sqlserver.msde)
  • Re: Calculating Date difference in 2 ways
    ... Just format the formula cell ... Hari wrote: ... > Why is there a diference in formatting of results between the above 2 ...
    (microsoft.public.excel.misc)