if exists (select * from systable t join syscolumn c on t.table_id = c.table_id and LCase(table_name) = LCase('InventoryOperations') and LCase(column_name) = LCase('RoomN')) then Update InventoryOperations set RoomN=0 where RoomN=-1 end if; GO