changing float value

[baran121]

hi. i want to change values of a table column.

exampe:
2300
1800
1200
1
54200
2354.46
121.12

in my table.

i want to do like that:
2.3
1.8
1.2
0.001
54.20
2.35446
0.12112

how can i do that with code.
please help me.

 

[r937]

update yourtable set yourcolumn = youcolumn / 1000

r937.com | rudy.ca

 

[baran121]

how cant i see that i didnt understand
thank you very much

 

[Geoka]

update TestTable set Amount=Amount/1000

 

[ca8msm]

update TestTable set Amount=Amount/1000

Did you read the previous posts?


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[SQLSister]

incidentally you should not store your numbrs as float. This division willnot give correct results in float as float is not an exact data type. All numbers you plan to do math on should be stored as numeric or decimal datatypes.

"NOTHING is more important in a database than integrity." ESquared

 

[r937]

All numbers you plan to do math on should be stored as numeric or decimal datatypes."

i disagree with this

what about scientific numbers? don't they fall within "all" numbers?

FLOAT has its place, although you are right, we should never use FLOAT for stuff like prices


r937.com | rudy.ca

 

[SQLSister]

OK rudy you are right, I've never needed scientific notation, so I didn't think about that.

"NOTHING is more important in a database than integrity." ESquared