So when I export a database entry I want to change a value from either Null or 0 to 1. I have found tons of example on how to add entries, but I am not sure how to edit one.

I currently I am thinking about just checking each value to see if it matches then deleting the record and adding a new one with the 1 instead of null/0. I just think there has to be a better way.

I am using a MSSQL database.