Updating a field

[lothos12345]

Can you update a field that you are searching by in sql?

 

For example

 

UPDATE temp SET ssn = 4 WHERE ssn = 5

 

Would the above sql statement work?

 

Any help given is greatly appreciated.

[HJB417]

your sql statement will work.