The 4th column already exists I just need to fill it depending on what query is run. I need to declare it but im having a mental block as everything I try seems to bring back an error saying syntax is wrong
for example - this does not work
insert into testtable (col1,col2,col3,col4)
set col4 =...