SQL - set certain records to nothing - not null or zero - as if no data was in the columns for selected rows
I am trying to update certain rows of a dbase and set certain columns in the rows to nothing. Someone has entered zeros in these columns and I need to update the table and set the rows back to empty (not null or zero)
have tried " " and ' ' but getting syntax errors. What can I use to set the rows back to empty as if there was no data there ?
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.