>REPLACE has another benefit
>
>REPLACE ;
>field1 with value1, ;
>field2 with value2
>
>is better than
>
>UPDATE (field1, field2) values (value1, value2)
>
>With long commands, having each field near the update value is a benefit.
Update
tablename set field1 = value1, field2 = value2;
where
conditionno confusion of what is going where
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place