Solved

use 1000 seperator for my price column

Posted on 2004-09-25
4
210 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
Comment Utility
Your front end application would have to format it.
0
 
LVL 49

Accepted Solution

by:
Ryan Chong earned 50 total points
Comment Utility
Try like:

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

Expert Comment

by:jdlambert1
Comment Utility
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

763 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

13 Experts available now in Live!

Get 1:1 Help Now