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.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Bob Barrows]

Joey Martin wrote:

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
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Joey Martin]

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!