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 |
|
vinothrao84
Starting Member
21 Posts |
 Posted - 2007-10-18 : 03:19:56
|
| Hi,I have the following table with its data.FUND_CODE........FUND_PRICE................DATETY..................0.35000001...................11/02/2007HO..................0.24000001...................22/03/2007BM..................0.59999999...................21/04/2007MB..................0.5..............................03/08/2007NI..................0.9210000.....................11/07/2007I want the result of a select statement to be like this.FUND_CODE........FUND_PRICETY..................0.3600HO..................0.2400BM..................0.6000MB..................0.5000NI..................0.9210Please help.....Thx..... |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-18 : 03:28:05
|
| Use the front end to format your results, not SQL ServerKristen |
 |
|
|
vinothrao84
Starting Member
21 Posts |
Posted - 2007-10-18 : 03:32:58
|
quote:
Originally posted by Kristen
Use the front end to format your results, not SQL ServerKristen
Ohh...SQL itself cannot be implement is it?I saw some function like CONVERT but don't know how to use. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-18 : 04:02:46
|
| "SQL itself cannot be implement is it?"It can, but its a bad way to write an application.Kristen |
|
|
|
|
|
|
FORMAT NUMBERS