Posted by Captain Paralytic on 02/16/07 15:47

On 16 Feb, 15:45, Rik <luiheidsgoe...@hotmail.com> wrote:
> 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 = 10
> > Add = 5
> > update field add 5 to field so field now = 15
> > but if field was null then field now = 5
>
> > Brian
>
> UPDATE `table` SET `field` = `field` + 5
>
> --
> Rik Wasmus

But that doesn't work if the field is currently NULL. See my post for
the solution.

[Back to original message]