Format Number in MSSQL

Posted on 2009-04-24
Medium Priority
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

Assisted Solution

by:Alpha Au
Alpha Au earned 450 total points
ID: 24223279
you can do this in the sql select statement
select convert(varchar, cast(1234567890.123 as money),1)

Open in new window


Assisted Solution

harkol earned 450 total points
ID: 24224034
LVL 12

Accepted Solution

North2Alaska earned 600 total points
ID: 24247143
How is FileMaker involved in this question?  Are you querying this data into FileMaker?

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Introduction: Sometimes when I receive a call from my users to solve their problems it is very difficult for me to found their computer IP address. Even finding their computer Host to provide remote support can be a problem.  So I resorted to Goo…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
Suggested Courses
Course of the Month8 days, 5 hours left to enroll

616 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