I don't think that CONCAT works with MS SQL Server. I have tried the following that does not give any error message but does not do what I want either.

    my $sqlB = "update ICD_9_Disease_Types set ICD_9_code = ('A') + IC
+D_9 FROM ICD_9 WHERE ICD_9 > 0";

    my $sthG = $dbh->prepare($sqlB) or $dbh->errstr();
    my $rows_updated = $sthG->execute();
    
    print "We updated $rows_updated rows\n";
[download]

It gives the message:

We updated 0E0 rows
[download]

I am not really sure what the OEO refers to.