Can I use multiple SET statements in an SQL UPDATE Clause<BR>e.g UPDATE SomeTable SET SomeName=SomeValue, SET AnotherName=AnotherValue etc<BR>WHERE Value = Something
the "set" keyword again. Just separate the fieldnames with commas.
Vineet thanks For your help<BR>Craig
Hi Craig,<BR><BR>You can write multiple update statements with a single SET but not with multiple SET statements
Thanks all for your advice