Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Set all the 0 values to NULL

Tags:

sql

sql-server

sql-server-2005

How can I set all the 0 values to NULL in an SQL table ?

Thanks in advance.

like image 283
Marshal Avatar asked Nov 22 '10 12:11

Marshal

1 Answers

update table set col = null where col = 0
like image 141
NimChimpsky Avatar answered Oct 05 '22 04:10

NimChimpsky
Sign in to Comment

Related questions

How do I fill a temp table iteratively and stuff() the result into columns?
Create a comma separated list from a column
Should I use Effective Date or Start Date and End Date for historical recording?
left join and group of inner join
Database error - RIGHT and FULL OUTER JOINs are not currently supported
How to use CASE statement inside a WHERE with an IN clause?
Modeling Geographic Locations in an Relational Database
SQL Select: Update if exists, Insert if not - With date part comparison?
How can I make SQL Developer/SQL+ prompt only once for a substitution variable that occurs multiple times in a single statement?
How to efficiently delete rows from a Postgresql 8.1 table?
Looking for T-SQL scripts to delete a SQL Job
What is "Linq to SQL"?
Recommended approach on handling SqlExceptions in db applications
Select only integers from char column using SQL Server
Sorting SQL by first two characters of fields
SQL: how to get the left 3 numbers from an int
Is there a [straightforward] way to order results *first*, *then* group by another column, with SQL?
LIKE work-around in SQL (Performance issues)
How to place stored procedure in desired location?
Howto use Rollback/Commit in Oracle SQL

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!