Reset to default in SQL

[Joey Martin]

Is it possible to reset a SQL field to it's default setting? For
example, someone changes FIELD1 to "John Doe" and the the default is
"YOUR NAME". Can I reset it back to "YOUR NAME" somehow?

Thanks for the help.

 

[Bob Barrows]

Is it possible to reset a SQL field to it's default setting? For
example, someone changes FIELD1 to "John Doe" and the the default is
"YOUR NAME". Can I reset it back to "YOUR NAME" somehow?

Thanks for the help.

I'm not quite sure I understand: if you know the default value, just

UPDATE table set FIELD1 = 'YOUR NAME'
WHERE FIELD1='John Doe'

Is that what you're after?

Or do you want a query that will work whatever the default value is? If so,
you can use the DEFAULT keyword:

UPDATE table set FIELD1 = DEFAULT
WHERE FIELD1='John Doe'

HTH,
Bob Barrows

 

[Joey Martin]

I was looking for the latter. It worked. Thanks!!