in reply to Win2K DBI SQL example sought

the actual execute statment will depend on what you pass into your handle's execute call...:
my $oldStrID = "foo"; my $newStrID = "bar"; $dbh->execute($newStrID,$oldStrID)
will generate sql that looks something like:
UPDATE Images SET strID='bar' WHERE strID='foo'