SQL server will allow zero-length strings without issue, as long as your datatype supports it. Just assign the string value of ('') and you're done, no headaches.

Microsoft Copilot can write basic SQL code for your employees. Read about our tests that prove this is true.