format a numeric values with commas

From: hari (anonymous_at_discussions.microsoft.com)
Date: 09/21/04

  • Next message: Cormac Mannion: "SQL problems" 
    Date: Tue, 21 Sep 2004 03:49:34 -0700

    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: Cormac Mannion: "SQL problems"

    Relevant Pages

    • Re: Import data into seperate columns
      ... I don't see the double quotes. ... utilizing the WEBMD_NSF Format. ... currently work in Patient Check-in. ... it doesn't "respect" the commas. ...
      (microsoft.public.excel.misc)
    • Re: Import data into seperate columns
      ... "Dave Peterson" wrote: ... utilizing the WEBMD_NSF Format. ... currently work in Patient Check-in. ... it doesn't "respect" the commas. ...
      (microsoft.public.excel.misc)
    • Re: Writing to a CSV file
      ... This is a data entry form, there will not be any data modification or ... > the posted code fails to place commas between the values ... > This isn't really Excel format. ... > formatted text or other features of excel at all... ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: Import data into seperate columns
      ... It appears you've changed commas to tilde signs. ... utilizing the WEBMD_NSF Format. ... currently work in Patient Check-in. ... By presenting this alert when the patient is chosen on the check in list, ...
      (microsoft.public.excel.misc)
    • Re: Problem With European Formatting of Amounts
      ... Finally format as currency ... "Tiziano" wrote in message ... > separator and commas for the decimals separator (i.e. $1.234,56 instead of ... > (commas instead of periods and vice-versa). ...
      (microsoft.public.excel.misc)