Home Forums SQL Server 2008 SQL Server 2008 - General Format the Amount RE: Format the Amount

  • May 18, 2013 at 6:19 pm

    #1616427

    shohelr2003 (5/18/2013)

    Dear,

    My client requires to add a hyphen(-) in lieu of comma(,) in the field of amount. But client requires only one hyphen(-) in the amount. For example, Total price is 10,000,000 but new requirement is 10-000000.

    Say if I execute "select amount from mytable". The result is '10-000000'. Here I need to do some formatting. But I have no idea.

    Please help me to sort out the problem.

    Rgds,

    Akbar

    No reflection on you, Akbar.

    That's one of the oddest formatting requirements I've ever seen for numeric values. Why on Earth does the client need it that way?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)