What is the most efficient way to FIND and MODIFY a record in a database? Please include a concise example if you will.
Update Table Set Field ='NewValue' Where Field =YourCriteria
What would that same SQL code look like if you had 3 fields to find and modify of a particular record?<BR><BR>... and say you want to modify the record where ID = 80<BR><BR>?
Update Table Set Field ='NewValue', Field2 ='NewValue', Field3 ='NewValue' Where ID =80
Thanks; just the concision I was looking for! <BR><BR>Any other tips about efficiently finding and modifying records would be appreciated. I will also read any article suggested.<BR><BR>