Whoops, I forgot I tried a different approach earlier and forgot to change it back.
I changed the table name, and no longer get any errors, but it is not updating the table.
Is my syntax correct on the substring, etc.
I am trying to extract 2020 out of 1234_2020_1234 and also filter on PORC_class great than "".
$UpdateQuery->addFilter("substring(record_number,6,4)", "=", "s", "".((isset($_POST["UpdateYear"]))?$_POST["UpdateYear"]:"") ." AND PORC_class>''");