format a numeric values with commas

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

  • Next message: chequerm: "SELECT query and then use of @RowCount" 
    Date: Tue, 21 Sep 2004 20:49:54 -0700

    hi,

    i don't know why it happened, but u can try using ur IP
    instead of localhost.
    ex: http:\\10.xx.xx.xx\

    >-----Original Message-----
    >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: chequerm: "SELECT query and then use of @RowCount"

    Relevant Pages