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 |
|
MikeM
Starting Member
6 Posts |
 Posted - 2007-09-12 : 11:58:13
|
| I have ran into something that I never needed before and have not been able to find a answer yet. Is there syntax that will allow me to remove a decimal point and show leading zeros? Example: I want 200.50 to be 00025050 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-12 : 12:06:47
|
Multiply by hundred?SELECT CAST(Col1 * 100 AS BIGINT)FROM Table1
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-12 : 12:07:29
|
SELECT REPLACE(STR(100 * Col1, 8, 0), ' ', '0')FROM Table1
E 12°55'05.25"N 56°04'39.16" |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-12 : 12:14:25
|
Same class?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
MikeM
Starting Member
6 Posts |
Posted - 2007-09-12 : 12:15:47
|
| Thank you! |
|
|
|
|
|
|
Do not want to display a decimal point