SQL staement to change field

want to update field from a to b

[weddingm]

I want to have an sql statement to UPDATE tablexyz.

Basically:

Select * FROM tablexyz and update field b from the value in field a and override what already exists in field b.

Thanks,
Matt

[Zipper]

This really belongs in the Database forum.. but ya, are you trying to copy the value in field a to field b? if so you can just simply run a update query like,

UPDATE tablexyz SET field_b = field_a WHERE <any conditions you want matched>

[weddingm]

awesome, thanks!