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.