Update Question

From: John (John_at_discussions.microsoft.com)
Date: 10/18/04

  • Next message: Anith Sen: "Re: Update Question" 
    Date: Mon, 18 Oct 2004 12:47:03 -0700

    can you update date a column with an if then statement. This is a simple
    example and I want to do something more complex, but I can't figure out how
    to do this simple example. can someone help?

    update car set field1 = (if (select passengers from car where id=1)='3' begin
    '2'
    end)

  • Next message: Anith Sen: "Re: Update Question"