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 |
|
baxterstockman
Starting Member
6 Posts |
Posted - 2011-03-01 : 15:53:51
|
| hey, i got a table with column and money value, how do i put i the money sign inside a column. So example: table1column1 542.6so what i want to get is, select column1 as column$ from table1: table1column$5$4$2.6$does anybody has an idea? thank you |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
baxterstockman
Starting Member
6 Posts |
Posted - 2011-03-01 : 17:42:43
|
| yeah, thats true, i know, but i use excel and in the excel sheet i got a button which changes the tables. so if i format one of these cells it shows the value of one case. so if you click the button (case two) it would still show the same value but thats not correct. in one case it should be $ in the other %. so is there a possibility to change change that in sql? |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|