>>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 :)