Replace Empty Strings With NULL
Easy
Data Cleaning
Some phone values were saved as empty strings. Return id and phone with empty strings converted to NULL, ordered by id.
Table schema
Customers(id INT PRIMARY KEY, phone VARCHAR(15))Sample data
id | phone
1 | 9876543210
2 | ''
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.