Converting data in one field from integer to decimal 1

[Cenedra]

Hi all,

I converted some legacy data into a SQL Server database. When I inserted data, I thought I was getting whole numbers. Unfortunately, that wasn't the case, so I inserted whole numbers into this particular field.

For example, in the legacy data, I had the value 200, and it is now in my SQL Server database as 200.00. Unfortunately, this is supposed to be 2.00.

Is there a way that I can move the decimal over two places to the left in a SQL Query so that my values will be correct?

Any help is appreciated,
Cen

 

[vongrunt]

If you got 200 and need 2.00 then simply divide number by 100.

------
heisenbug: A bug that disappears or alters its behavior when one attempts to probe or isolate it
schroedinbug: A bug that doesn't appear until someone reads source code and realizes it never should have worked, at which point the program promptly stops working for everybody until fixed.
[ba

 

[Cenedra]

Well.... duh on my part there. Having all sorts of problems and not thinking clearly there

Can I do that in a query? Or do I need to write a program to do it?

 

[Cenedra]

Well I really think I need some coffee.

This worked:

update clients set maoverage=(maoverage / 100)