I need to find a way other than a loop to update the same field in different rows at one time. The loop takes too lond. Thanks.
Try<BR><BR>UPDATE tablename SET field = value WHERE field = value<BR><BR>I'm not sure if that's what you're getting at, though, but I hope it helps.<BR><BR>Ben
you should be able to just do<BR>UPDATE tblContact SET tblContact.memNotes = "zoinks";<BR>and this would set every entry under the field memNotes to "zoinks".<BR>