Posted by Rik on 02/16/07 15:45

On Fri, 16 Feb 2007 16:30:26 +0100, Brian <djswirl@remove_me_yahoo.com> =
=

wrote:

> 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 =3D 10
> Add =3D 5
> update field add 5 to field so field now =3D 15
> but if field was null then field now =3D 5
>
> Brian

UPDATE `table` SET `field` =3D `field` + 5

-- =

Rik Wasmus

[Back to original message]