SQL Statement

[pinkpanther2070]

I want to update a field to reflect a new value in the record, I'm currently using a statement that looks like this:

"Update * From table_name"

However I'm missing something because I get an error that says syntax error.

Can you help me out with this?

Thanks
PinkPanther

[pvb]

basic format:

UPDATE
TargetTable
SET
Field1=Value1,
Field2=Value2,
Field3=Value3
[ WHERE <search condition> ]


There can be a lot more to an update statement, look in BOL for the complete UPDATE syntax