Solved

use 1000 seperator for my price column

Posted on 2004-09-25
4
214 Views
Last Modified: 2008-01-09
hi
i have a question about one of my column in table
i have a float column --> price
i wanna use 1000 seperator for my price column
how can i do that
tanxfull
Mahsa
0
Comment
Question by:Mahsa60
4 Comments
 
LVL 6

Expert Comment

by:curtis591
ID: 12150355
Your front end application would have to format it.
0
 
LVL 50

Accepted Solution

by:
Ryan Chong earned 50 total points
ID: 12150431
Try like:

Select CONVERT(varchar, CAST(myprice AS money), 1) from mytable
0
 
LVL 15

Expert Comment

by:jdlambert1
ID: 12150561
Both front-end and cast-to-money/convert-with-style-1 will work. If you have a small amount of data to deal with, performance difference will be insignificant. If you have millions of records to work with, a well-written front-end formatting is likely to give the best performance, since it can do it in a single function, rather than 2 functions.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to share SSIS Package? 6 37
transaction in asp.net, sql server 6 33
New to SSRS, extremely slow running report. 8 20
SQL server vNext 18 29
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

778 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