Update fields by a percentage? 1

[dflanagan]

Hello all!
Hopefully this is easy!

I need to update a whole range of fields by a percentage. basically I want to muliply the field by a number and place the result in that field and then move on to the next record and multiply by the same number, etc etc etc

How do I do this?

Thanks!

Dave

 

[Golom]

UPDATE myTable

SET myField = myField * 1.10

Increases "myField" by 10% for every record in the table.

[small]On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question. (Charles Babbage)[/small]

 

[dflanagan]

HAHAHAHAA! DUH!

You know when you have those brain farts that really make you look stupid? Just had one!

Thanks man! Who knows how long I would have let that beat me up.

I will just finish that offf with a where clause, and I will be golden.

Star for you!!

Dave