Format Number in MSSQL

Posted on 2009-04-24
Last Modified: 2012-05-06
In my ms sql database, i have a numeric field. i have written a stored procedure to retreive the output from the table. I would want my output to be displayed with commas. Eg. If the answer is 123000 - it should be displayed as 1,23,000 which would clearly imply as 1 lakh 23 thousand.

Is this possible?
Question by:RajeshPixel
    LVL 7

    Assisted Solution

    you can do this in the sql select statement
    select convert(varchar, cast(1234567890.123 as money),1)

    Open in new window


    Assisted Solution

    LVL 12

    Accepted Solution

    How is FileMaker involved in this question?  Are you querying this data into FileMaker?

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
    The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now