Posted by Brian on 02/16/07 15:30

Hi there

I'm sure this can be done but not sure of the MSQL code

I want to run an update statement on a field where it adds
X to want ever is already in the field?

e.g.
field = 10
Add = 5
update field add 5 to field so field now = 15
but if field was null then field now = 5

Brian



--------------------------------------------------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 2353 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!

[Back to original message]