Edit a mssql easy script. This can be ongoing work like this for me as well but I need fast turnaround times.

I need 1 line of mssql edited to properly run a specific script on my server from my website. In this line the website searches for one column only (to see if there is a "1" in it), GotDL, I want it to also search for the same thing in other columns so it would have all of these at the same time looking for the same "1": GotDL, GotDLud1, GotDLud2, GotDLud3. It should allow me to see which has a 1 in it, the next line would allow me to run this script and turn all "1" into "0" in every column at the same time. I need these lines, nothing else.