>>>What can be more concise than REPLACE a WITH b?
>>
>>Sorry Bill but this gave me a chuckle. How is that concise? You don't say if b is a field or a memvar and you don't say the alias. ;) Just kidding around.
>
>UPDATE Table SET Column = 'some value'
>
>Pretty concise to me :)

We discovered a bug yesterday. 1 REPLACE only allows 128 a with b sets and gives a syntax error if you go beyond that, whereas SQL gives a too many fields in update error, if you go beyond 256. Even it's bug reporting is more concise. :)

However, one of my pet peeves about SQL is why do they use SET column = value in the UPDATE command, but

INSERT INTO TABLE (field1, field2, field3, field4, field5)
values (asdgagrwsf,asdfasg,asdfkaflka,asfkslkasklf,afklasdlka)

I find it hard to match the values against the field names. IMO it would be better
INSERT INTO TABLE (
field=asdgagrwsf,
field2=asdfasg,
field3=asdfkaflka)