Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jimbojames30
Starting Member
8 Posts |
 Posted - 2014-11-25 : 14:42:18
|
Hi all,Sorry for the newbies question, but my google search doesn't really give a clear result, I would like to change the format of a result set, I have a field called totalBasePrice, it's current a numeric value like 10000 but I wish for it to be displied like £10,000Is this possible please can some one help me outI appreciate you taking the time to read this post, new to sql server  |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-11-25 : 14:55:09
|
| This is a presentation layer issue and not something done in T-SQL, meaning you would do this formatting in your application and not on the database side. I don't know what formatting options your application's programming language has.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
akibintel
Starting Member
7 Posts |
Posted - 2014-11-25 : 23:39:52
|
| DECLARE @Pound AS moneySET @Pound = 500SELECT PoundAmount='£'+CONVERT(VARCHAR,@Pound) Thanks & Regards |
|
|
|
|
|
|
Numbers to show as pound £