IF ( select count(sc.table_id) from sys.syscolumn as sc == sys.systable as st
  where LCase(st.table_name)= LCase('Articles') and LCase(sc.column_name)= LCase('VATRate') ) = 0 then
alter table Articles
  add "VATRate" numeric(3,3) not null default 0
end if;
 
GO

IF ( select count(sc.table_id) from sys.syscolumn as sc == sys.systable as st
  where LCase(st.table_name)= LCase('ProArticles') and LCase(sc.column_name)= LCase('VATRate') ) = 0 then
alter table ProArticles
  add "VATRate" numeric(3,3) not null default 0
end if;
  
GO

IF ( select count(sc.table_id) from sys.syscolumn as sc == sys.systable as st
  where LCase(st.table_name)= LCase('Services') and LCase(sc.column_name)= LCase('VatRateN') ) = 0 then
alter table Services
add "VatRateN" integer not null default 2
end if;

GO

IF ( select count(sc.table_id) from sys.syscolumn as sc == sys.systable as st
  where LCase(st.table_name)= LCase('VaucherArticles') and LCase(sc.column_name)= LCase('VATRate') ) = 0 then
alter table VaucherArticles
  add "VATRate" numeric(3,3) not null default 0
end if;

GO

IF ( select count(sc.table_id) from sys.syscolumn as sc == sys.systable as st
  where LCase(st.table_name)= LCase('VatRates') and LCase(sc.column_name)= LCase('Active') ) = 0 then
alter table VatRates
  add "Active" integer not null default 1
end if;
 
GO

update VatRates set Active = 0 where ID=3

GO

update VatRates set Rate = 0.09 where ID=4