Select Code to Download

#---SQL to change the column data
for ($count = 0; $count < $EasySetDataCount; $count++) {
...
$sqlCmd->execute()
    or die "SQL Error: $DBI::errstr\n";
}

Uncaught exception from user code:
        SQL Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Inva
+lid column name 'Other'. (SQL-42S22)
...
 at C:\temp\EasySetRenameTool.pl line 155
Issuing rollback() for database handle being DESTROY'd without explici
+t disconnect() at C:\temp\EasySetRenameTool.pl line 155, <STDIN> line
+ 5.
UPDATE AI_ESP SET Race = red WHERE Race = Other