Doh! >Video = split(trim(Videos),",") made absolutely no difference in removing the extra space in front of the video id. >RS.Source = "Update tblVideos SET CheckedIn = 1 WHERE Video = '" & Video(counter) & "'" to ... '" & trim(Video(counter)) & "'... made the loop work.. sorry, Rob