Post reply

How to insert comma to a money or number field?

  • April 5, 2006 at 9:24 am

    #112791

    Now I need to format all the number and money fields with comma in sql 2000 tables, maybe not in the database, but must be show comma in the query results screen, anybody knows how to do it?

    I really appreciate any help!!

  • April 5, 2006 at 9:31 am

    #631041

    Declare

    @Mon Money

    Set

    @Mon = 1345.00

    Select

    convert(varchar(30), @Mon, 1)

    Results:

    1,345.00

     

  • April 5, 2006 at 9:54 am

    #631049

    Thanks a lot, that's exactly what I want.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply